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
1 Like
What if you want your formula to round up to the nearest dollar?
Hi Catherine,
In this case, simply use:
ROUND({Amount},0)
23.5 => 24
23.2 => 23
If you really want to round UP:
ROUNDUP({Amount},0)
23.5 => 24
23.2 => 24
Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.