# MROUND Function in Excel – Round to nearest multiple in Excel

MROUND Function in Excel rounds the number up or down to the nearest multiple of the supplied argument (multiple)

#### Syntax of MROUND Function in Excel

MROUND( number,multiple)

number – The number to be rounded

multiple – The number used to choose the nearest multiple while rounding

#### Example of MROUND Function in Excel

##### Formula • In Row number 2 the value 97 is Rounded up to the nearest multiple of 10 i.e. 100
• In Row number 3 the value 9 is Rounded down to the nearest multiple of 4 i.e. 8
• In Row number 4 the value 11 is rounded up to the nearest multiple of 4 i.e 12
• In Row number 5 the value 33.3 is rounded down to the nearest multiple of 1 i.e 33
• In Row number 6 the value -23.3 is rounded up to the nearest multiple of -1 i.e -23

So the result will be

##### Result Note: #VALUE! Error occurs if the supplied arguments are non-numeric.

#NUM!   – Error occurs if the multiple argument and Number argument have different signs

##### Example: 