Shares

# How To Use Excel MROUND Function

## Quick Intro

Excel MROUND Function can help us to round a number to the nearest multiple of a number. While rounding a number it will not consider that number is greater or lower than the original number.

In below example, I have used excel mround function to get the nearest multiple of 5 from 12. The nearest multiple is 10 from 12 & this is what we get.

## Syntax

MROUND(number, multiple)

• number Number to round.
• multiple A number for which you want to find the nearest multiple.

## More Information on Excel MROUND Function

• If you put zero in multiple it will return zero in the result.
• If you skip specifying multiple it will return with an error.
• It rounds away from zero. If you have two multiples on the same distance it will return the multiple which is higher than the number you are rounding.

## Examples

In above example, I have used different arguments to make you understand the concept of mround.

1. 12.5 rounded to 12 to the nearest multiple of 3 is 12.
2. 19 is rounded to 20 to the nearest multiple of 5
3. 13 is rounded to 12 to the nearest multiple of 6.
4. 3.6 is rounded to 2 to the nearest multiple of 4.
5. The result is 0 as I have skipped specifying multiple.
6. The result is 0 as I have specified 0 as the multiple.
7. The result is an error as I have specified -2 as multiple.
8. Here we have a tie between 20 & 18, but we get 20 as it always rounds away from zero.

## What’s Next?

To learn more about Excel MROUND Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have INT function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.