Help

Rounding up a number to nearest 50

Topic Labels: Formulas
1372 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Soumas
4 - Data Explorer
4 - Data Explorer

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