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