A measured MROUND gallery: nearest multiples, the same-sign #NUM! rule, halves and time rounding — every assertion engine-verified. Live, free.
Two arguments. Rounds to the nearest multiple; halves away from zero; opposite signs give #NUM!.
MROUND rounds to the nearest multiple of a significance — up or down, whichever is closer (halves away from zero). Unlike CEILING/FLOOR it has no forced direction. Every row measured live in HyperFormula. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =MROUND(10,3) | 9 | Nearest multiple of 3 below 10 |
| =MROUND(11,3) | 12 | Nearest multiple of 3 above 11 |
| =MROUND(1.5,1) | 2 | Half rounds away from zero |
| =MROUND(-10,-3) | -9 | Same-sign multiple, nearest |
| =MROUND(7,0.5) | 7 | Already a multiple of 0.5 |
| =MROUND(2.6,0.5) | 2.5 | Nearest half |
| =MROUND(1234,100) | 1200 | Nearest hundred |
| =MROUND(7,2) | 8 | Nearest even multiple |
| Expression | Result | Why |
|---|---|---|
| =MROUND(10,3) | 9 | Both positive: fine |
| =MROUND(-10,-3) | -9 | Both negative: fine |
| =MROUND(10,-3) | #NUM! | Opposite signs → error |
| Expression | Result | Why |
|---|---|---|
| =MROUND(10,3) | 9 | Nearest (9 is closer than 12) |
| =CEILING(10,3) | 12 | Forced up to next multiple |
| =FLOOR(10,3) | 9 | Forced down to multiple below |
All presets are exact and engine-stable, including the #NUM! sign-mismatch case.
10 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
MROUND is universal across Excel, Google Sheets and LibreOffice Calc with the same same-sign requirement.
| Platform | Support | Notes | Gotcha |
|---|
MROUND is one piece. The full course walks the toolkit end to end with live, measured examples.