Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Rounding up a number to nearest 50

posted Aug 18, 2020 9:20:58 PM

Topic Labels: Formulas

0 697 1

I am trying to create a formula to roundup a number to the next highest multiple of 50. Can help much appreciated.

1 Reply 1

This formula should work:

ROUNDUP(number/50,0)*50