Excel MROUND Function

Related Functions:
CEILING Function
FLOOR Function
Excel Rounding Functions

The Excel Mround function is one of fifteen rounding functions in Excel.

A full list, along with comparison tables, is provided on the Excel Rounding Functions page.

Function Description

The Excel Mround function rounds a supplied number up or down to the nearest multiple of a given number.

The syntax of the function is:

MROUND( number, multiple )

Where the arguments are as follows:

number - The number to be rounded.
multiple -

The multiple that the supplied number should be rounded to.

Note: The multiple argument should have the same arithmetic sign (positive or negative) as the number argument.


Mround Function Examples

Column B of the following spreadsheet shows several examples of the Mround function:

 Formulas:
  A B
1 number Mround
2 333.7 =MROUND( A2, 0.5 )
3 333.8 =MROUND( A3, 1 )
4 333.3 =MROUND( A4, 2 )
5 555.3 =MROUND( A5, 400 )
6 555 =MROUND( A6, 1000 )
7 -555.7 =MROUND( A7, -1 )
8 -555.4 =MROUND( A8, -1 )
9 -1555 =MROUND( A9, -1000 )
 Results:
  A B
1 number Mround
2 333.7 333.5
3 333.8 334
4 333.3 334
5 555.3 400
6 555 1000
7 -555.7 -556
8 -555.4 -555
9 -1555 -2000

The above examples show how the Mround function rounds the supplied number to the nearest multiple of the supplied multiple argument. This may involve rounding up or down.


See the Microsoft Office website for further details and examples of the Excel Mround Function.


Mround Function Errors

If you get an error from the Excel Mround function, this is likely to be one of the following:

Common Errors
#NUM! - Occurs if the multiple argument has a different arithmetic sign (positive or negative) to the number argument.
#VALUE! - Occurs if any of the supplied arguments are non-numeric.