MROUND function

MROUND returns a number rounded to a specified multiple.


MROUND(number, multiple)

  • number is the value to be rounded.
  • multiple is the multiple to which you want to round the number.
Note: It returns the #NUM! error if number and multiple have different signs.


=MROUND(15.5,3) returns 15, because 15.5 is closer to 15 (=3*5) than to 18 (=3*6).