A measured CEILING gallery: up-to-multiple rounding, the same-sign rule and the mode-argument gotcha — every assertion engine-verified. Live, free.
Rounds up, away from zero, to the nearest multiple of significance.
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.
| Expression | Result | Why |
|---|---|---|
| =CEILING(2.5,1) | 3 | Up to the next whole multiple |
| =CEILING(10,3) | 12 | Next multiple of 3 above 10 |
| =CEILING(-2.5,-1) | -3 | Same-sign: away from zero |
| =CEILING(2.5,0.5) | 2.5 | Already a multiple of 0.5 |
| =CEILING(1234,100) | 1300 | Next hundred above |
| =CEILING(7,1) | 7 | Exact multiple unchanged |
| =CEILING(0.01,0.1) | 0.1 | Tiny value up to next tenth |
| =CEILING(12,5) | 15 | Next multiple of 5 |
| Expression | Result | Why |
|---|---|---|
| =CEILING(10,3) | 12 | Forced up |
| =FLOOR(10,3) | 9 | Forced down |
| =MROUND(10,3) | 9 | Nearest |
| Expression | Result | Why |
|---|---|---|
| =CEILING(-2.5,-1) | -3 | Same sign: away from zero (works) |
| =CEILING(-2.5,1) | -2 here | HF toward-zero; Excel needs a mode arg |
| =CEILING(-2.5,1,-1) | #N/A here | mode arg unsupported in HyperFormula |
Same-sign presets are exact and engine-stable; the mode-argument deviation is documented.
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.
CEILING is universal; same-sign arguments behave identically across Excel, Google Sheets and LibreOffice. The mode argument varies by platform.
| Platform | Support | Notes | Gotcha |
|---|
CEILING is one piece. The full course walks the toolkit end to end with live, measured examples.