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.

E.g.

1277.78 - how do i round it up to 1279

1014.88 - how do i round it up to 1019

 

 

3 Replies

@PrasadGK1995 

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. 

TY

@PrasadGK1995 

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