Excel MROUND Function
The Excel MROUND function returns a number rounded to a given multiple. MROUND will round a number up or down, depending on the nearest multiple.
- number - The number that should be rounded.
- multiple - The multiple to use when rounding.
The MROUND function rounds a number to the nearest given multiple. If a number is already an exact multiple, no rounding occurs and the original number is returned.
Example #1 - round to nearest 5
To round a number in A1 to the nearest multiple of 5, you can use MROUND like this:
=MROUND(A1,5) // round to nearest 5
Example #2 - round pricing to nearest .99
MROUND can be used to round pricing to end with .99. The formula below will round a value in A1 to the nearest 1 dollar, subtract 1 cent, and return a final price like $2.99, $5.99, $49.99, etc.
=MROUND(A1,1) - 0.01 // round to nearest .99
Example #3 - round time to nearest 15 minutes
MROUND can be used to round time. To round a time in A1 to the nearest 15 minutes, you can use a formula like this:
=MROUND(A1,"0:15") // round to nearest 15 min
Rounding functions in Excel
Excel provides a number of functions for rounding:
- To round normally, use the ROUND function.
- To round to the nearest multiple, use the MROUND function.
- To round down to the nearest specified place, use the ROUNDDOWN function.
- To round down to the nearest specified multiple, use the FLOOR function.
- To round up to the nearest specified place, use the ROUNDUP function.
- To round up to the nearest specified multiple, use the CEILING function.
- To round down and return an integer only, use the INT function.
- To truncate decimal places, use the TRUNC function.
- If a number is already an exact multiple, no rounding occurs.
- Rounding occurs when the remainder from dividing number by multiple is greater than or equal to half the value of multiple
- Number and multiple must have the same sign.