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.
Page 1 / 1
Hello
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.