Round up numbers to either a half or a whole depending on which side of 0.5 it is
Hi
Thanks for the two replies both of you. They both work, but if the sum does
equal say 15.5 then they both round that up to 16 and not leave it at 15.5
Perhaps I should have said that in the original post
Regards
John
"John Williams" wrote in message
...
Hi
Is there any way in Excel 2002 to do the above.
E.g.
My vertical sum comes to 15.2 so I want that changed to 15.5
or
My vertical sum comes to 15.6 so I want that changed to 16
It doesn't matter if the rounding takes place in a different cell to the
sum.
TIA
John
|