Math & trig · rounding · Nov 16, 2026

The ROUND function,
measured & explained.

ROUND rounds a number to a set number of digits — halves go away from zero. Negative digits round to tens, hundreds, thousands. This page measures ROUND against ROUNDUP, ROUNDDOWN and TRUNC so you can see exactly which direction each takes.

D1
fx
=ROUND(3.14159, 2)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How ROUND works

Returns a number. Halves round away from zero (2.5→3, -2.5→-3). Negative num_digits rounds left of the decimal.

=ROUND(number, num_digits)
numberThe value to round.
num_digitsDigits to keep: >0 right of the decimal, 0 to integer, <0 to tens/hundreds/thousands.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Rounding directions

What ROUND actually returns

Same number, five functions, five answers. ROUND goes to the nearest (halves away from zero); ROUNDUP/ROUNDDOWN force a direction; TRUNC chops toward zero. Every row was measured live in HyperFormula. Click any row to load it.

Rounding-direction gallery

ExpressionResultWhy
=ROUND(3.14159,2)3.14Nearest hundredth
=ROUND(2.5,0)3Half rounds away from zero
=ROUND(-2.5,0)-3Negative half rounds to -3, not -2
=ROUNDUP(3.21,1)3.3Always away from zero
=ROUNDDOWN(3.89,1)3.8Always toward zero
=ROUND(1234.5,-2)1200Negative digits round to hundreds
=TRUNC(-3.7)-3Chops the decimal toward zero
=ROUND(999,-3)1000Negative digits round to thousands

Negative digits round left of the decimal

ExpressionResultWhy
=ROUND(1234.5,-1)1230-1 → tens
=ROUND(1234.5,-2)1200-2 → hundreds
=ROUND(999,-3)1000-3 → thousands
⚠ ROUND halves go away from zero: ROUND(2.5,0)=3 and ROUND(-2.5,0)=-3 — not banker's rounding. TRUNC chops toward zero (TRUNC(-3.7)=-3); Excel's INT floors negatives (INT(-3.7)=-4), a different rule.
Formatting only changes the display; ROUND changes the stored value used by later math. Use ROUND when the rounded number must be the real number — currency, tax, invoices.
// 03 — Try it live

Interactive ROUND playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to see ROUND go to the nearest, force a direction with ROUNDUP/ROUNDDOWN, and round to hundreds with negative digits.

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

The real-world error library

8 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 ROUND works

ROUND, ROUNDUP, ROUNDDOWN and TRUNC are available in Excel 2003+, Microsoft 365, Excel for the web and Google Sheets. Excel's INT floors negatives (INT(-3.7)=-4); this page's live engine truncates, so INT negative cases are prose-only.

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

Master rounding

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

  • ROUND vs ROUNDUP vs ROUNDDOWN vs TRUNC
  • Half-away-from-zero, not banker's rounding
  • Negative digits: tens, hundreds, thousands
  • Formatting vs actually changing the value
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked