ExcelFunctions.net

Excel MROUND Function

Related Functions:
Home » Excel-Built-In-Functions » Excel-Math-Functions » Excel-Mround-Function

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 initial number
multiple -

The multiple that the supplied number should be rounded to.

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


Mround Function Examples

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 up or down, to the nearest multiple of the supplied multiple argument.

Further information on the Excel Mround Function is provided on the Microsoft Office website.


Mround Function Error

If you get an error from the Excel Mround function, this is likely to be the #NUM! error :

Common Error
#NUM! - Occurs if the multiple argument has a different sign (positive or negative) as the initial number argument.