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: