Rounding up to next number 9

New Contributor

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.


1277.78 - how do i round it up to 1279

1014.88 - how do i round it up to 1019



3 Replies


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. 



Let's say your numbers are in B2 and down.

Enter the following formula in C2, then fill down: