Math · Head-to-head

ROUND vs MROUND

Both round to a grid, but the grids differ. ROUND snaps to a decimal place — tenths, hundreds, thousandths (a power-of-10 grid). MROUND snaps to the nearest multiple of any number you choose — 5, 0.5, 100, 0.25. Below, the same values hit both grids, live.

fx
ROUND(…)  vs  MROUND(…)
23.5 vs 25
Place vs nearest 5
#NUM!
MROUND sign mismatch
0
MROUND(x,0)
1200
Hundreds: both agree
▶ Try both live See the feature matrix
🏆Verdict: Two different grids

ROUND snaps to a decimal place (power-of-ten grid); MROUND snaps to any multiple and needs matching signs. ROUND(23.456,1)=23.5 but MROUND(23.456,5)=25; MROUND(-23.456,5)=#NUM! while MROUND(-23.456,-5)=-25; MROUND(x,0)=0.

ROUND strengths

  • Currency to 2 decimal places.
  • Scores or measurements to 1 place.
  • Rounding to tens/hundreds with negative digits.
  • Standard half-away-from-zero rounding.

MROUND strengths

  • Pricing to the nearest 5 or 0.99 grid.
  • Time to the nearest 0.5 or 0.25 hour.
  • Packaging / batches to a custom multiple.
  • Any grid that is not a power of ten.

Feature-by-feature matrix

The two rounding grids compared.

CapabilityROUNDMROUNDWhy it matters
Rounds to decimal places✓ num_digits✗ No places conceptROUND(23.456,1)=23.5; MROUND has no tenths notion.
Rounds to an arbitrary multiple✗ Powers of ten only✓ Any multipleMROUND(23.456,5)=25; ROUND cannot target 5.
Negative num_digits / multiple✓ Left of decimal✓ Matching-sign multipleROUND(1234,-2)=1200; MROUND(1234,100)=1200.
Half-away-from-zero ties✓ 2.5→3✓ 2.5→3 (mult 1)Both round halves away from zero.
Sign restriction✗ Any sign✓ Must match signMROUND(-23.456,5)=#NUM!; ROUND is unaffected.
Zero second argument✓ ROUND(x,0)=integer✓ MROUND(x,0)=0MROUND returns 0, it does not error.
Custom grid (0.25, 5, 0.5)✗ Not expressible✓ DirectOnly MROUND targets non-power-of-ten grids.

Syntax, side by side

num_digits (a place) vs multiple (any grid).

ROUND

ROUND(number, num_digits)
numberThe value to round.
num_digitsDecimal places: positive right, 0 integer, negative left.
=ROUND(23.456,1) → 23.5

MROUND

MROUND(number, multiple)
numberThe value to round.
multipleThe target multiple; must share the number's sign.
=MROUND(23.456,5) → 25

Live head-to-head playground

One editable numeric column, two rounders. Pick a scenario or type your own — see the grids diverge and the sign trap.

A1Sample data — click any cell to edit; both formulas re-evaluate live

ROUND

—

MROUND

—
HyperFormula 3.5 · live

Every difference, measured

These are not feature-list claims. Each pair below was evaluated on the identical dataset in the HyperFormula 3.5 engine, and the outputs are baked from that run. Reproduce them in the playground above.

One decimal place vs nearest 5

23.456 rounded to one decimal place vs to the nearest 5.
ROUND
=ROUND(23.456,1)
23.5
MROUND
=MROUND(23.456,5)
25
ROUND(23.456,1)=23.5 (tenths grid); MROUND(23.456,5)=25 (nearest 5). Different grids, different answers.

Negative, same-sign multiple

A negative number with a matching-sign multiple.
ROUND
=ROUND(-23.456,1)
-23.5
MROUND
=MROUND(-23.456,-5)
-25
With matching signs MROUND works: MROUND(-23.456,-5)=-25; ROUND(-23.456,1)=-23.5.

Negative number, positive multiple

A negative number with a positive multiple — the sign trap.
ROUND
=ROUND(-23.456,1)
-23.5
MROUND
=MROUND(-23.456,5)
#NUM!
Opposite signs: MROUND(-23.456,5)=#NUM! (measured). ROUND is unaffected: -23.5.

Tenths place vs 0.5 multiple

7.3 to the tenths place vs to the nearest 0.5.
ROUND
=ROUND(7.3,1)
7.3
MROUND
=MROUND(7.3,0.5)
7.5
MROUND(7.3,0.5)=7.5 (nearest half); ROUND(7.3,1)=7.3 (already at tenths).

Negative places vs 100 multiple

1234 to hundreds: a power-of-ten grid where both coincide.
ROUND
=ROUND(1234,-2)
1200
MROUND
=MROUND(1234,100)
1200
Both grids coincide here: ROUND(1234,-2)=1200 == MROUND(1234,100)=1200.

Already on the grid

A value already on the target grid — no change.
ROUND
=ROUND(25,0)
25
MROUND
=MROUND(25,5)
25
Already on the grid: ROUND(25,0)=25, MROUND(25,5)=25 — no change.

Zero multiple

A zero multiple: MROUND returns 0 rather than erroring.
ROUND
=ROUND(23.456,0)
23
MROUND
=MROUND(23.456,0)
0
MROUND(23.456,0)=0 (measured; a zero multiple returns 0). ROUND(23.456,0)=23.

Engine benchmark

Engine cost rounding a numeric stream (relative only, not Microsoft Excel).

Table sizeROUNDMROUND
1,000 rows × 200 lookups4.65 ms3.92 ms
5,000 rows × 200 lookups3.69 ms2.87 ms
10,000 rows × 200 lookups2.86 ms2.83 ms
Measured in the HyperFormula 3.5 engine on this page, not in Microsoft Excel. Both round a single number; absolute times are engine-specific and only meaningful as a relative signal.

Which one should you use?

Pick by which grid you need.

SituationUseWhy
Round 23.456 to 1 decimalROUNDROUND(23.456,1)=23.5; MROUND has no places concept.
Round 23.456 to nearest 5MROUNDMROUND(23.456,5)=25; ROUND cannot target 5.
Round -23.456 to nearest 5MROUNDUse MROUND(-23.456,-5)=-25; positive 5 gives #NUM!.
Round to nearest 0.5MROUNDMROUND(7.3,0.5)=7.5; ROUND(7.3,1)=7.3.
Round 1234 to hundredsEitherROUND(1234,-2)=1200 == MROUND(1234,100)=1200.
Round to nearest 0.25MROUNDOnly MROUND can target a non-power-of-ten grid.

ROUND → MROUND migration

Common rounding tasks, side by side.

TaskROUND / old wayMROUNDWhat changed
Currency to 2 places=ROUND(price,2)=MROUND(price,0.01)Equivalent on a power-of-ten grid; ROUND is simpler.
Charm pricing to nearest 5not expressible=MROUND(price,5)ROUND cannot target a 5 grid.
Timesheet quarter-hours=ROUND(hours*4,0)/4=MROUND(hours,0.25)MROUND expresses the 0.25 grid directly.
Present thousands=ROUND(value,-3)=MROUND(value,1000)Both coincide on the power-of-ten grid.

Frequently asked questions

What is the difference between ROUND and MROUND?
ROUND rounds to a number of decimal places (a power-of-10 grid). MROUND rounds to the nearest multiple of any number you specify. Measured: ROUND(23.456,1)=23.5, MROUND(23.456,5)=25.
Why does MROUND return #NUM!?
When the number and the multiple have opposite signs. MROUND(-23.456,5) is #NUM! (measured); use MROUND(-23.456,-5)=-25. ROUND has no such restriction.
How do I round to the nearest 5 or 0.5?
Use MROUND: MROUND(value,5) or MROUND(value,0.5). ROUND cannot target a non-power-of-ten grid (measured: MROUND(7.3,0.5)=7.5).
What does MROUND(x,0) return?
0 (measured), not an error. If your multiple can be zero by accident, guard it so you do not silently zero out values.
When do ROUND and MROUND agree?
When the multiple is a power of ten matching the place: ROUND(1234,-2)=1200 equals MROUND(1234,100)=1200 (measured). For custom grids like 5 or 0.25, only MROUND applies.