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
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
Log into the Pigment Community
No account yet? Create an account
Single Sign-On Need help?
Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.