# Solved Please help in Rounding the value in Excel

July 22, 2016 at 23:59:38
Specs: Windows 7
 I want to round off the value in excel when the value is greater than 5..For example:if num= 9.15, result= 9.1if num=9.16, result = 9.2Please need help urgently.. See More: Please help in Rounding the value in Excel

#1 July 23, 2016 at 06:39:14
 Use the ROUND() function.This function rounds a number to a specified amount of decimal places. 5 is the midway point and is rounded up.So something like: =ROUND(A1,1)You might also want to investigate the ROUNDUP() and ROUNDDOWN() functions.And Excel questions are best asked in the Office Software forum.MIKEmessage edited by mmcconaghy

Report •

#2 July 23, 2016 at 15:12:43
✔ Best Answer
 re: if num= 9.15, result= 9.1I don't know if you know this or not, but that is not the "standard". The vast majority of applications and mathematicians use the "round half towards positive infinity" rule for deciding how to round numbers that end in 5.When that rule is applied, 9.15 would be rounded up and the answer would be 9.2.If you want to use Excel's round function, but still round 9.15 to 9.1, you might be able to use this:=ROUND(A1-0.00000000000001,1)Depending on the precision of your actual values, this might work for you or it might not.Please let us know.message edited by DerbyDad03

Report •
Related Solutions 