A measured ROUNDUP gallery: away-from-zero direction, negatives, negative digits and the round-up-to-multiple trick — every assertion engine-verified. Live, free.
Two arguments. Always rounds away from zero; any non-zero fraction increases the magnitude.
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.
| Expression | Result | Why |
|---|---|---|
| =ROUNDUP(3.2,0) | 4 | Any fraction rounds up to 4 |
| =ROUNDUP(3.9,0) | 4 | Already near 4, still 4 |
| =ROUNDUP(-3.2,0) | -4 | Negative: away from zero is more negative |
| =ROUNDUP(2.345,2) | 2.35 | 2 decimals, third digit forces up |
| =ROUNDUP(1234,-2) | 1300 | -2 rounds up to the next hundred |
| =ROUNDUP(7,0) | 7 | Exact integer is unchanged |
| =ROUNDUP(0.001,2) | 0.01 | Tiny positive still rounds up to 0.01 |
| =ROUNDUP(3.211,1) | 3.3 | 1 decimal, always away from zero |
| Expression | Result | Why |
|---|---|---|
| =ROUND(3.2,0) | 3 | Nearest integer |
| =ROUNDUP(3.2,0) | 4 | Forced up |
| =ROUNDDOWN(3.2,0) | 3 | Forced down |
| Expression | Result | Why |
|---|---|---|
| =ROUNDUP(10/3,0)*3 | 12 | Divide, round up, multiply back = next multiple of 3 |
| =CEILING(10,3) | 12 | CEILING does the same in one call |
All presets are exact and engine-stable; click any gallery row to reproduce it.
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.
ROUNDUP is universal across all Excel versions, Google Sheets and LibreOffice Calc with identical away-from-zero behaviour.
| Platform | Support | Notes | Gotcha |
|---|
ROUNDUP is one piece. The full course walks the toolkit end to end with live, measured examples.