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.
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.
The two rounding grids compared.
| Capability | ROUND | MROUND | Why it matters |
|---|---|---|---|
| Rounds to decimal places | ✓ num_digits | ✗ No places concept | ROUND(23.456,1)=23.5; MROUND has no tenths notion. |
| Rounds to an arbitrary multiple | ✗ Powers of ten only | ✓ Any multiple | MROUND(23.456,5)=25; ROUND cannot target 5. |
| Negative num_digits / multiple | ✓ Left of decimal | ✓ Matching-sign multiple | ROUND(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 sign | MROUND(-23.456,5)=#NUM!; ROUND is unaffected. |
| Zero second argument | ✓ ROUND(x,0)=integer | ✓ MROUND(x,0)=0 | MROUND returns 0, it does not error. |
| Custom grid (0.25, 5, 0.5) | ✗ Not expressible | ✓ Direct | Only MROUND targets non-power-of-ten grids. |
num_digits (a place) vs multiple (any grid).
One editable numeric column, two rounders. Pick a scenario or type your own — see the grids diverge and the sign trap.
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.
=ROUND(23.456,1)=MROUND(23.456,5)=ROUND(-23.456,1)=MROUND(-23.456,-5)=ROUND(-23.456,1)=MROUND(-23.456,5)=ROUND(7.3,1)=MROUND(7.3,0.5)=ROUND(1234,-2)=MROUND(1234,100)=ROUND(25,0)=MROUND(25,5)=ROUND(23.456,0)=MROUND(23.456,0)Engine cost rounding a numeric stream (relative only, not Microsoft Excel).
| Table size | ROUND | MROUND |
|---|---|---|
| 1,000 rows × 200 lookups | 4.65 ms | 3.92 ms |
| 5,000 rows × 200 lookups | 3.69 ms | 2.87 ms |
| 10,000 rows × 200 lookups | 2.86 ms | 2.83 ms |
Pick by which grid you need.
| Situation | Use | Why |
|---|---|---|
| Round 23.456 to 1 decimal | ROUND | ROUND(23.456,1)=23.5; MROUND has no places concept. |
| Round 23.456 to nearest 5 | MROUND | MROUND(23.456,5)=25; ROUND cannot target 5. |
| Round -23.456 to nearest 5 | MROUND | Use MROUND(-23.456,-5)=-25; positive 5 gives #NUM!. |
| Round to nearest 0.5 | MROUND | MROUND(7.3,0.5)=7.5; ROUND(7.3,1)=7.3. |
| Round 1234 to hundreds | Either | ROUND(1234,-2)=1200 == MROUND(1234,100)=1200. |
| Round to nearest 0.25 | MROUND | Only MROUND can target a non-power-of-ten grid. |
Common rounding tasks, side by side.
| Task | ROUND / old way | MROUND | What 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 5 | not 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. |