Forum Discussion
Rounding up to next number 9
I have several numbers in my excel sheet with 2 decimal places. I am trying to figure out how I can round it up to the next higher number 9. E.g. 1277.78 - how do i round it up to 1279 1014.88 - ...
Let's say your numbers are in B2 and down.
Enter the following formula in C2, then fill down:
=CEILING(B2+1,10)-1
or
=ROUNDUP(B2+1,-1)-1