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 - how do i round it up to 1019
3 Replies
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
Hello! You've posted your question in the Away from Keyboard space, which is intended for more casual, non-tech-themed conversations and not for conversations on products and services. I apologize if that was unclear for any reason. I'm moving your question to the Excel space - please post Excel questions here in the future.
