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

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: