# How to use Excel MROUND Function

0
764

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’.