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 About Excel MROUND Function

- If you put zero in multiple it will return zero in the result.
- If you skip to specify 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 created different situations 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 is Next?

To learn more about Excel MROUND Function you can check Microsoft’s Help Section.

There are also some functions like INT | TRUNC which are highly useful with index function.

Apart from this, I have a list of excel functions and some real life formulas examples.

And, if you have a unique idea to use mround function, I would love to hear from you.