Math · rounding · Nov 2026

The CEILING function,
measured & explained.

A measured CEILING gallery: up-to-multiple rounding, the same-sign rule and the mode-argument gotcha — every assertion engine-verified. Live, free.

D1
fx
=CEILING(2.5,1)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How CEILING works

Rounds up, away from zero, to the nearest multiple of significance.

=CEILING(number, significance, [mode])
numberThe value to round up to a multiple.
significanceThe multiple; keep the same sign as number for portability.
modeOptional; direction for mixed signs (unsupported in HyperFormula).
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Up to a multiple

What CEILING actually returns

CEILING rounds up to the nearest multiple of a significance, away from zero. It is the multiple-aware cousin of ROUNDUP. Every row measured live in HyperFormula. Click any row to load it.

Ceiling gallery — up to a multiple

ExpressionResultWhy
=CEILING(2.5,1)3Up to the next whole multiple
=CEILING(10,3)12Next multiple of 3 above 10
=CEILING(-2.5,-1)-3Same-sign: away from zero
=CEILING(2.5,0.5)2.5Already a multiple of 0.5
=CEILING(1234,100)1300Next hundred above
=CEILING(7,1)7Exact multiple unchanged
=CEILING(0.01,0.1)0.1Tiny value up to next tenth
=CEILING(12,5)15Next multiple of 5

CEILING vs FLOOR vs MROUND on 10, multiple 3

ExpressionResultWhy
=CEILING(10,3)12Forced up
=FLOOR(10,3)9Forced down
=MROUND(10,3)9Nearest

Sign and the mode argument

ExpressionResultWhy
=CEILING(-2.5,-1)-3Same sign: away from zero (works)
=CEILING(-2.5,1)-2 hereHF toward-zero; Excel needs a mode arg
=CEILING(-2.5,1,-1)#N/A heremode arg unsupported in HyperFormula
⚠ For a negative number with a positive significance, Excel's CEILING uses a third mode argument to pick direction. HyperFormula 3.5 does not support mode (returns #N/A) and computes CEILING(-2.5,1)=-2. Keep number and significance the same sign for portable, unambiguous results.
Use CEILING to never under-shoot a multiple: carton quantities, price points ending in .99, minimum billable increments. Same-sign arguments behave identically everywhere.
// 03 — Try it live

Interactive CEILING playground

Same-sign presets are exact and engine-stable; the mode-argument deviation is documented.

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

CEILING is universal; same-sign arguments behave identically across Excel, Google Sheets and LibreOffice. The mode argument varies by platform.

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

Master multiples

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

  • CEILING vs FLOOR vs MROUND direction
  • The same-sign rule and mode gotcha
  • Pricing and pack-size rounding
  • When forced-up multiples are right
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked