Roundup

[Stclements1]

I am trying to roundup a value in a cell whose value is calculated from a formula
In cell K13 I am trying to divide the value of F13 (21930) by the value in K2 (4.00) and then Roundup that value to the nearest 100 so the value in K13 is 5482.46 and I want that to round up to 5500, so I type in the cell K13 =ROUNDUP(F13/K2,100) but all I get is the same answer 5482.46. Any help with this would be much appreciated.

 

[Scott Huish]

=ROUNDUP(F13/K2,-2)

 

[Phuoc]

Or try:

=CEILING(F13/K2,100)

 

[Stclements1]

Or try:

=CEILING(F13/K2,100)

Many thanks this worked perfectly

 

[Stclements1]

=ROUNDUP(F13/K2,-2)

many thanks for this

 

[Peter_SSs]

many thanks for this

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

Note also that I have told you about this before, recently.