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.
Round a number to the nearest specified multiple
A rounded number.
=MROUND (number, multiple)
- number - The number that should be rounded.
- multiple - The multiple to use when rounding.
- MROUND rounds up, away from zero.
- The rounding occurs when the remainder left from dividing number by multiple is greater than or equal to half the value of multiple.
- Number and multiple must have the same sign.
MROUND formula examples
To round a time to the nearest 15 minute interval, you can use the MROUND function, which rounds based on a supplied multiple. In the example shown, the formula in C6 is: =MROUND(B6,"0:15") How this formula...
If you need to round a number to the nearest specified multiple (i.e. round a number to the nearest dollar, nearest $.25, nearest multiple of 5 or 10, etc) you can use the MROUND function. In the example, the formula...
If you need to round a number to the nearest multiple of 5, you can use the MROUND function and supply 5 for number of digits. How this formula works In the example, cell C6 contains this formula: =MROUND(B6,5) The...