Rounding to Multiples With MROUND
Snap numbers to the nearest five, ten, or any multiple.
Snapping to a Multiple
Sometimes you do not want to round to a number of decimals, but to the nearest multiple: the nearest 5 cents, nearest 10 dollars, or nearest quarter hour.
The MROUND function does exactly that. Instead of asking how many decimals to keep, it asks what step size to snap to. This lesson shows how to round to any multiple you like.
The MROUND Syntax
MROUND takes two arguments:
- number the value to round
- multiple the step to round to
It returns the nearest multiple of that step. For example =MROUND(23, 5) rounds 23 to the nearest 5, which is 25, because 23 is closer to 25 than to 20.
=MROUND(23, 5)All lessons in this course
- Rounding With ROUND, ROUNDUP, ROUNDDOWN
- Truncating With INT and TRUNC
- Rounding to Multiples With MROUND
- Formatting Numbers as Text With TEXT