Math · rounding · Nov 2026

The MROUND function,
measured & explained.

A measured MROUND gallery: nearest multiples, the same-sign #NUM! rule, halves and time rounding — every assertion engine-verified. Live, free.

D1
fx
=MROUND(10,3)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How MROUND works

Two arguments. Rounds to the nearest multiple; halves away from zero; opposite signs give #NUM!.

=MROUND(number, multiple)
numberThe value to round to a multiple.
multipleThe significance; must share the sign of number.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Nearest multiple

What MROUND actually returns

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.

Nearest-multiple gallery

ExpressionResultWhy
=MROUND(10,3)9Nearest multiple of 3 below 10
=MROUND(11,3)12Nearest multiple of 3 above 11
=MROUND(1.5,1)2Half rounds away from zero
=MROUND(-10,-3)-9Same-sign multiple, nearest
=MROUND(7,0.5)7Already a multiple of 0.5
=MROUND(2.6,0.5)2.5Nearest half
=MROUND(1234,100)1200Nearest hundred
=MROUND(7,2)8Nearest even multiple

The sign rule — number and multiple must match

ExpressionResultWhy
=MROUND(10,3)9Both positive: fine
=MROUND(-10,-3)-9Both negative: fine
=MROUND(10,-3)#NUM!Opposite signs → error

MROUND vs CEILING vs FLOOR on 10, multiple 3

ExpressionResultWhy
=MROUND(10,3)9Nearest (9 is closer than 12)
=CEILING(10,3)12Forced up to next multiple
=FLOOR(10,3)9Forced down to multiple below
⚠ MROUND returns #NUM! when number and multiple have opposite signs (MROUND(10,-3)). Make the multiple match the sign of the number, or use ABS. A multiple of 0 returns 0, not an error.
Use MROUND for nearest pricing ticks, time rounding (nearest 15 min = MROUND(t,15/1440)) and packaging multiples. Use CEILING/FLOOR when the direction must be forced.
// 03 — Try it live

Interactive MROUND playground

All presets are exact and engine-stable, including the #NUM! sign-mismatch case.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

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.

// 05 — Cross-platform

Where MROUND works

MROUND is universal across Excel, Google Sheets and LibreOffice Calc with the same same-sign requirement.

PlatformSupportNotesGotcha
✓ Supported full MROUND◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master multiples

MROUND is one piece. The full course walks the toolkit end to end with live, measured examples.

  • MROUND vs CEILING vs FLOOR direction
  • The same-sign #NUM! rule
  • Rounding times and pricing ticks
  • Halves and zero-multiple behaviour
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked