MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Rounding Up


Posted by San on December 07, 2000 10:01 AM

I am trying to round up a sum of numbers to a decimal of .5 if the decimal is .4999 or less or to the next whole number if the decimal is .51 or greater. Please respond with the exact formula.

Thanks.


Posted by JDF on December 07, 2000 1:27 PM

Try setting your decimal to 1 or 2 places, should round properly.

Posted by Tim Francis-Wright on December 07, 2000 2:40 PM

The following should round up to the nearest 0.5:
=ROUNDUP(A1*2,0)/2
It rounds double the number up to the nearest whole number, then divides by 2.
The net effect si to round up to the nearest 0.5.

Posted by Celia on December 07, 2000 3:18 PM


If your numbers are in A1:A10 :-

=MROUND(SUM(A1:A10),0.5)

Posted by Celia on December 07, 2000 3:39 PM


Ignore previous post. I misread the question.
Using Tim's formula, you might want to change it to :-
=ROUNDUP(SUM(A1:A10)*2,0)/2

Celia