What formula can you use to round a number up the the nearest 10 increment? For example, if the number would be 31, I would need it to round up to 40.
One way is to divide by the “place” that you want to round to, round up to zero decimals then multiply by the “place”. In your example you want to round to the “10’s” place. So, divide by 10, round up then multiply by 10.
Here’s a formula:
ROUNDUP(31 / 10, 0) * 10
To round up 314159 to 1000’s (=315000):
ROUNDUP(314159 / 1000, 0) * 1000
Jim - The Monday Man
Do you wish there was an app that.… Visit the Wishing Well
We Create Custom Apps, Integrations & Automations for monday