MROUND Function in Excel

What this does

MROUND rounds to the nearest multiple of a step you specify, rather than to a number of decimal places. It is the only one of the rounding family that picks the nearest step in either direction: CEILING always goes up and FLOOR always goes down. Exact halves round away from zero, so =MROUND(7.5, 5) returns 10. The one hard rule is that number and multiple must share a sign — mixing a positive value with a negative step returns #NUM! rather than guessing. Because a time in Excel is a fraction of a day, MROUND is the standard way to snap timestamps to a 15-minute or half-hour grid. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “mround function in excel”. Start on a copy or a tiny sample, keep the affected formula visible, and compare the result with the outcome you expected before you touch the real workbook. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. The point is a calculation you can defend to a CFO or an auditor, but the practical win is that someone else can open the file and understand what happened without asking you.

A worked example

Rounding a price to the nearest 0.05 for cash handling: =MROUND(12.37, 0.05) returns 12.35. Snapping a meeting time in A2 to the nearest quarter hour: =MROUND(A2, "0:15") returns the nearest 15-minute slot. Batching an order to whole cases of 12: =MROUND(94, 12) returns 96. MROUND is how you snap messy real-world values onto a business-defined grid — price points, case sizes, time slots — in a single readable formula. Check the referenced cells, argument order and result type in your workbook. Start with the worked example before changing an input, then compare the changed result with the calculation you expected. An error value or a result of a different type is a reason to inspect the inputs and arguments.

In Google Sheets

Google Sheets support for this task has not been verified. Check the function, arguments and workflow in the target product before transferring the example. Matching formula notation does not establish identical behaviour. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. For “mround function in excel”, keep the input cells and the result visible while you check the formula in Excel. Follow the worked example and change one input at a time. The steps explain the workbook calculation; this page does not run a live calculator for that task.

Common mistakes

• Passing a positive number with a negative multiple (or vice versa), which returns #NUM! — both arguments must share a sign.
• Reaching for MROUND when the requirement is strictly one-directional; a price that must never round down needs CEILING, not the nearest multiple.
• Rounding times without formatting the result as time, which shows the underlying decimal fraction instead of a clock value.

Frequently asked questions