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.
- Author
- 12 replies
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.