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

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

## Sample File

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