This tutorial explains the usage of Excel MROUND function with syntax and examples. The Excel MROUND function returns a number rounded up or down to the desired multiple of a given number. The function belongs to the Excel ROUND family and always rounds up, away from zero, if the remainder from dividing number by multiple is greater than or equal to half the value of multiple.
Uses: Excel MROUND Function
Use MROUND if number is required to round to the nearest instance of specified multiple. For example, if you want to round to the nearest multiple of 5 (five), 5 must be used as multiple and some of the multiple of 5 are, 10, 15, 20, 25, and 30. It follows the general math rounding rules to round to the nearest multiple.
For example, the function =MROUND (13, 5) rounds 13 to the nearest multiple of 5 and returns 15 as the answer.
Syntax: Excel MROUND Function
MROUND (number, multiple)
Arguments: Excel MROUND Function
- number: the number to round.
- multiple: the required multiple to which you want to round the number.
Examples: Excel MROUND Function
As you see below, I have taken different types of examples to make you understand the real-use of MROUND function in Excel.
In the examples given above:
- On row 2, function rounds 58 to the nearest multiple of 3, i.e. 57.
- On row 4, the function returns 0 (zero) because the multiple is supplied as 0.
- On row 6, the result is 0 as the multiple is missing.
- On row 7, both number and multiple arguments are not supplied in the same sign, hence returned #NUM! error.
- On row 9, the result is again 0 and that is because of ‘number’ is less than half of the ‘multiple’.
Additional Notes: –
- Both arguments, number and multiple must have the same sign. If not, #NUM! error is returned by MROUND function.
- The function occurs #VALUE! error if either argument contains non-numeric values.
- If either argument is zero, the result is 0 by the MROUND function.
- MROUND either rounds up or down, depending on the remainder from dividing the number by multiple argument:
- If the leftover is equal to or greater than 5 of the multiple, the last digit is rounded up.
- If the remainder is less than half of the multiple, the last digit is rounded down.