Math · rounding · Nov 2026

The ROUNDUP function,
measured & explained.

A measured ROUNDUP gallery: away-from-zero direction, negatives, negative digits and the round-up-to-multiple trick — every assertion engine-verified. Live, free.

D1
fx
=ROUNDUP(3.2,0)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How ROUNDUP works

Two arguments. Always rounds away from zero; any non-zero fraction increases the magnitude.

=ROUNDUP(number, num_digits)
numberThe value to round away from zero.
num_digitsPlace: >0 decimals, 0 integer, <0 tens/hundreds/thousands.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Always away from zero

What ROUNDUP actually returns

ROUNDUP never rounds to nearest — it forces the magnitude up, away from zero, for any non-zero fraction. Positive numbers grow, negative numbers grow more negative. Every row measured live in HyperFormula. Click any row to load it.

Direction gallery — away from zero

ExpressionResultWhy
=ROUNDUP(3.2,0)4Any fraction rounds up to 4
=ROUNDUP(3.9,0)4Already near 4, still 4
=ROUNDUP(-3.2,0)-4Negative: away from zero is more negative
=ROUNDUP(2.345,2)2.352 decimals, third digit forces up
=ROUNDUP(1234,-2)1300-2 rounds up to the next hundred
=ROUNDUP(7,0)7Exact integer is unchanged
=ROUNDUP(0.001,2)0.01Tiny positive still rounds up to 0.01
=ROUNDUP(3.211,1)3.31 decimal, always away from zero

ROUND vs ROUNDUP vs ROUNDDOWN on 3.2

ExpressionResultWhy
=ROUND(3.2,0)3Nearest integer
=ROUNDUP(3.2,0)4Forced up
=ROUNDDOWN(3.2,0)3Forced down

Round up to a multiple (ceiling trick)

ExpressionResultWhy
=ROUNDUP(10/3,0)*312Divide, round up, multiply back = next multiple of 3
=CEILING(10,3)12CEILING does the same in one call
⚠ ROUNDUP is not ROUND. ROUND(3.2,0)=3 but ROUNDUP(3.2,0)=4 — even a 0.0001 fraction pushes the value up. For negatives, away from zero means more negative: ROUNDUP(-3.2,0)=-4, not -3.
Use ROUNDUP when you must never under-estimate: packing boxes, billing units, capacity planning. num_digits<0 rounds left of the decimal (-2 → hundreds). For rounding to a multiple, prefer CEILING.
// 03 — Try it live

Interactive ROUNDUP playground

All presets are exact and engine-stable; click any gallery row to reproduce it.

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 ROUNDUP works

ROUNDUP is universal across all Excel versions, Google Sheets and LibreOffice Calc with identical away-from-zero behaviour.

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

Master rounding

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

  • ROUNDUP vs ROUND vs ROUNDDOWN direction
  • Negative numbers and negative digits
  • Round up to a multiple with CEILING
  • When forced-up rounding is the right choice
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked