Skip to main content

Rounding up a number to nearest 50

  • August 19, 2020
  • 1 reply
  • 11 views

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

1 reply

ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8853 replies
  • August 19, 2020

This formula should work:

ROUNDUP(number/50,0)*50


Reply