Solved Rounding. Hi I have to round 2.45 ,2.46,2.47 to the nearest

March 22, 2013 at 10:19:53
Specs: Windows 7
Hi I have to round 2.45 ,2.46,2.47 to the nearest whole number, that would be 3. How can I do this in excel.

See More: Rounding. Hi I have to round 2.45 ,2.46,2.47 to the nearest

Report •


#1
March 22, 2013 at 10:32:26
Check the =ROUNDUP() function.

MIKE

http://www.skeptic.com/


Report •

#2
March 22, 2013 at 11:06:50
Thank you but unfortunately it's not useful. ROUND function round from 0.5 to 1, but I need to round from 0.45 to 1. Thinking of conditionals...

Report •

#3
March 22, 2013 at 11:10:57
✔ Best Answer
If you re-read my reply I did not indicate the =ROUND() function
I said check the =ROUNDUP() function.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question