how to use excel mround functionExcel 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.

10 is the nearest multiple of 5 using Excel MRound FUnction

 

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

Examples To Learn Excel MRound Function

In above example, I have created different situations 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.

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.