Excel MROUND 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.

Basic 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.

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:

2333.7=MROUND( A2, 0.5 )
3333.8=MROUND( A3, 1 )
4333.3=MROUND( A4, 2 )
5555.3=MROUND( A5, 400 )
6555=MROUND( A6, 1000 )
7-555.7=MROUND( A7, -1 )
8-555.4=MROUND( A8, -1 )
9-1555=MROUND( A9, -1000 )

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.

For further details and examples of the Excel Mround Function, see the Microsoft Office website.

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.