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.

- If the leftover is equal to or greater than 5 of the

**Related Tips:-**