MROUND Function
Rounds a number to the nearest multiple you choose.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Want to practice MROUND in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
MROUND rounds to the nearest multiple of any number — the nearest 5, 0.25, 15 minutes or pack size.
Halfway values round away from zero.
Syntax
=MROUND(number, multiple) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The value to round. |
| multiple | Yes | The multiple to round to. Must have the same sign as number. |
Examples
Example 1 — Prices to the nearest 5 cents
Cash prices without pennies.
B2fx=MROUND(A2, 0.05)
| A | B | |
|---|---|---|
| 1 | Price | Cash price |
| 2 | 4.32 | 4.3 |
| 3 | 4.33 | 4.35 |
| 4 | 9.98 | 10 |
=MROUND(A2, 0.05) Explain
Example 2 — Times to the nearest 15 minutes
Round clock-in times for the timesheet.
=MROUND(A2, "0:15") Explain
Common mistakes
- #NUM! with mixed signs. MROUND(−7, 5) fails because the signs differ. Use MROUND(−7, −5).
Notes
- Related functions: CEILING.MATH, FLOOR.MATH, ROUND.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.