Skip to main content

I want to round to the nearest ten or hundred. Example: 223,453 --> 223,450 or 223,500. I tried the round formula but it didn’t work.

Hello @Joanna 

My recommendation would be to divide your value by either 10 or 100, then apply a ROUND function, and afterward multiply it by the value you initially divided by. Ex:

 


Or if you need it using 100:

 


Hope this helps
Regards,
Alberto Garneri

Thank you. That worked!

it’s odd that it didn’t like like Excel formula with round (-2)

Reply


Ask your question here!

Terms & ConditionsCookie settings