Syntax
MROUND(number, multiple)
| Parameter | Description |
|---|---|
| number | Parameter of the MROUND function. |
| multiple | Parameter of the MROUND function. |
Examples
Round to nearest nickel
Formula
=MROUND(3.47, 0.05)
Returns 3.45. Since 3.47 is closer to 3.45 than to 3.50, MROUND rounds down.
Round to nearest 15 minutes
Formula
=MROUND(2.33, 0.25)
Returns 2.25. 2.33 hours is closer to 2.25 (2h15m) than to 2.50 (2h30m).
Round to nearest 500
Formula
=MROUND(1280, 500)
Returns 1500. 1280 is closer to 1500 than to 1000, so it rounds up.
Common Errors
#NUM!
The number and multiple must have the same sign. =MROUND(5, -1) returns #NUM!.
#VALUE!
Non-numeric arguments cause this error.
Tips
Halfway rounds away from zero
When the number is exactly halfway between two multiples, MROUND rounds away from zero. =MROUND(2.5, 5) returns 5.
Pricing application
Use MROUND(price, 0.99) to round prices to the nearest x.99 value (though this requires a different approach — MROUND works with even multiples).
Compare with FLOOR and CEILING
MROUND goes nearest, FLOOR always down, CEILING always up. Choose based on whether you want conservative, aggressive, or balanced rounding.
Try MROUND in Viztab
Import your data and use MROUND with 370+ other formulas. No signup required.
Open Viztab