Excel MROUND Function

Excel MROUND Function

Related Functions


Round a number to the nearest specified multiple

Return value 

A rounded number.


=MROUND (number, multiple)


  • number – The number that should be rounded.
  • multiple – The multiple to use when rounding.

Usage notes 

MROUND rounds up, away from zero.

The rounding occurs when the remainder left from dividing number by multiple is greater than or equal to half the value of multiple.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas