The Excel MROUND function rounds a number to the nearest multiple of a value you choose — ideal for snapping to the nearest 5, 25, 0.05, or any other increment.
Syntax
| Argument | Description | |
|---|---|---|
number | Required | The number you want to round. |
multiple | Required | The multiple to round to. Must have the same sign as number, or MROUND returns an error. |
How to use it
MROUND finds the nearest multiple of the second argument, rounding half away from zero when the value sits exactly halfway:
Unlike CEILING and FLOOR, MROUND can go either direction — it picks whichever multiple is closer. It's perfect for pricing to the nearest nickel or scheduling to the nearest 15 minutes.
Signs must match. number and multiple must share the same sign. =MROUND(5, -2) returns an error; use =MROUND(-5, -2) instead.
Try it: interactive demo
Pick a MROUND example to see the formula and its result.
Practice workbook
Frequently asked questions
How does MROUND decide which way to round?
=MROUND(17, 5) is 15 (17 is closer to 15 than 20); =MROUND(23, 5) is 25. Exact halves round away from zero.Why does MROUND return an error?
number and multiple have different signs. They must match: round a negative number with a negative multiple.How is MROUND different from ROUND?
Can MROUND round to the nearest quarter hour?
=MROUND(timevalue, "0:15") snaps to the nearest 15 minutes.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class