The Excel ROUNDUP function, explained interactively.
ROUNDUP always rounds a number away from zero — positives move up, negatives move down. No half-rule, no “ties” logic: any non-zero fraction pushes the value to the next digit. The right tool for ceiling-style calculations like capacity planning, packaging sizes, and price surcharges where every fractional unit needs a whole-unit count.
How to use ROUNDUP
- Type
=ROUNDUP(and supply the number — a cell reference, literal, or any formula returning a number. - Add a comma and num_digits — where to round to.
0for the nearest integer, a positive value for decimals, a negative value for tens / hundreds / thousands. - Close the parenthesis. The result always moves away from zero —
99.49rounds to100atnum_digits = 0, never99. - For standard half-up rounding, reach for ROUND. For always-toward-zero, ROUNDDOWN. For rounding to a specific multiple (like “next 50”), use CEILING.
Flip the num_digits picker in the demo — 0 rounds to the next integer (watch row 4: 99.49 → 100, not 99). -2 snaps to the next hundred up. The dataset is identical to the ROUND demo so the differences are visible row by row.
-7.85 becomes -7.86, not -7.84.0 = nearest integer, negative = tens / hundreds / thousands. Zero is the default “round up to whole number” choice.| A | B | |
|---|---|---|
| 1 | Source | ROUNDUP (digits=0) |
| 2 | 3.14159 | 4 |
| 3 | 12.75 | 13 |
| 4 | 0.125 | 1 |
| 5 | 99.49 | 100 |
| 6 | 154.6 | 155 |
| 7 | -7.85 | -8 |
| 8 | 12345.678 | 12346 |
=ROUNDUP(A2, 0). num_digits = 0: rounds away from zero to the nearest integer. 99.49 → 100 (never 99, regardless of how small the fraction is). -7.85 → -8 (also away from zero).ROUNDUP syntax and arguments
Two required arguments, no optionals. See Microsoft’s official ROUNDUP reference for the canonical specification.
A2), literal (3.14159), or any formula returning a number. Text that can coerce to a number works ("3.14" → 3.14); anything else returns #VALUE!.2 = two decimal places (currency ceiling); 0 = nearest integer away from zero; -2 = nearest hundred away from zero. Decimals in num_digits are truncated toward zero.ROUNDUP examples
Four patterns that cover most real-world ROUNDUP use.
Example 1: ROUNDUP — capacity planning for whole units
The canonical case. You have 1,234 items and ship them in pallets of 100 — how many pallets? Always the next whole pallet up, never down.
With A2 = 1234: returns 13 pallets. Without ROUNDUP, a simple division gives 12.34 — but you can’t ship 0.34 of a pallet. Same pattern for servers, buses, filing boxes, shipping containers.
Example 2: ROUNDUP — price ceilings
Some pricing rules round always up to the next cent or dime to avoid sub-penny billing. ROUNDUP to 2 decimals is the standard implementation.
With A2 = 14.99 (price) and an 8.75% tax rate: raw is 1.311625. ROUNDUP to 2 decimals returns 1.32. Important in jurisdictions that mandate always-up tax rounding, or in pricing engines that avoid apparent rounding losses over millions of transactions.
Example 3: ROUNDUP with negative num_digits
Snap a value to the next multiple of 10, 100, or 1,000. Useful for allocation calculations and nearest-next-thousand dashboards.
With A2 = 47500: returns 48000. Negative num_digits counts to the left of the decimal — -3 means nearest thousand above. For nearest exact multiple other than powers of 10 (like 50 or 250), use CEILING instead.
Example 4: ROUNDUP for pagination
How many pages does a list of N items need at K items per page? Always round up — the last page might be half full, but it still exists.
COUNTA returns the non-blank row count; dividing by 25 gives pages; ROUNDUP to 0 digits ensures 76 items → 4 pages, not 3.04. Drop-in pattern for any “batches of N” calculation where rounding down would leave orphans.
Common ROUNDUP errors and fixes
Four failure modes, each with what to check and how to recover.
ROUNDUP result feels wrong on negative numbers
Cause: ROUNDUP rounds away from zero, so -7.85 becomes -7.86 (more negative). Users expecting mathematical ceiling (toward +infinity) are surprised.
For mathematical ceiling behaviour on negatives, use CEILING.MATH(value, significance, 0). Or explicitly flip: use ROUNDDOWN on negatives and ROUNDUP on positives based on sign. ROUNDUP’s absolute-value semantics are correct for pricing and capacity use cases.
ROUNDUP returns #VALUE!
Cause: the input is text that won’t coerce to a number — currency with symbols, percentages stored as text, values with thousand separators.
Strip the non-numeric characters or use VALUE() where possible: =ROUNDUP(VALUE(SUBSTITUTE(A2, "$", "")), 2). Or fix upstream by applying Number format instead of Text before entering the data.
ROUNDUP rounds when you didn’t want it to
Cause: any non-zero fraction rounds — including tiny floating-point artefacts like 0.1 + 0.2 = 0.30000000000000004. ROUNDUP at 1 decimal returns 0.4, not 0.3.
Pre-round to clean the floating-point noise: =ROUNDUP(ROUND(A2 + B2, 10), 2). The inner ROUND strips artefacts past the 10th decimal; the outer ROUNDUP then applies the real ceiling rule on the clean value.
ROUNDUP rounds 0 away from zero
Cause: zero is exactly zero — no fraction to round. ROUNDUP(0, 0) returns 0, as expected. But ROUNDUP(0.0001, 0) returns 1, which surprises users reading sparse data.
Guard with IF if you want tiny values treated as zero: =IF(ABS(A2) < 0.01, 0, ROUNDUP(A2, 0)). Or apply a threshold filter upstream. Floating- point noise below a meaningful threshold shouldn’t reach ROUNDUP in the first place.
ROUNDUP vs ROUND, ROUNDDOWN & CEILING
Four rounders, each with a distinct rule. Pick by which direction you want fractions to go.
| Function | Rule | Args | Typical use |
|---|---|---|---|
| ROUNDUP | Always away from zero | number, num_digits | Capacity planning, pagination, price ceilings |
| ROUND | Half-up (0.5 rounds away from zero) | number, num_digits | Financial reporting, display rounding |
| ROUNDDOWN | Always toward zero | number, num_digits | Tax withholding floors, conservative estimates |
| CEILING | To nearest multiple of significance | number, significance | Round to 50, 250, 0.05 — any non-power-of-10 multiple |
Rule of thumb: ROUNDUP when you always want “the next whole unit” (pages, pallets, servers); ROUND for normal half-up display rounding; ROUNDDOWN when you never want to overstate (conservative tax, available inventory); CEILING when the increment isn’t a power of 10 (round to nearest $0.25, nearest 50 units).
ROUNDUP frequently asked questions
6.01ROUNDUP vs ROUND: what’s the difference?▸
ROUND uses the half-up rule — 0.5 and above round up, below 0.5 round down. ROUNDUP ignores the half-rule entirely: any non-zero fraction rounds away from zero. ROUND(1.01, 0) returns 1; ROUNDUP(1.01, 0) returns 2. Use ROUNDUP when you want ceiling behaviour — capacity planning, packaging sizes, “always round up to the next whole unit”.
6.02How does ROUNDUP handle negative numbers?▸
Away from zero — so negatives get more negative. ROUNDUP(-7.85, 1) returns -7.9, not -7.8. Conceptually ROUNDUP is absolute-value-based: it rounds the magnitude up and preserves the sign. If you want mathematical ceiling (always toward +infinity, so -7.85 → -7.8), use CEILING.MATH instead.
6.03Can ROUNDUP take negative num_digits?▸
Yes — negative num_digits rounds to the nearest tens / hundreds / thousands above the current value. ROUNDUP(1234, -2) returns 1300 (next hundred up). Useful for capacity planning: “how many pallets of 100 do we need for 1,234 units” is exactly =ROUNDUP(1234, -2) / 100 = 13.
6.04Does ROUNDUP work on text numbers?▸
It tries — Excel coerces text that looks like a number to a real number before rounding. ROUNDUP("3.14", 1) returns 3.2. But text with units, currency symbols, or thousand separators fails with #VALUE!. Wrap with VALUE() or strip the non-numeric parts before passing in.
6.05What’s the difference between ROUNDUP and CEILING?▸
ROUNDUP rounds to a number of digits (away from zero). CEILING rounds to a multiple of a specified significance (toward positive infinity, by default). CEILING(1234, 50) returns 1250 — the next multiple of 50. ROUNDUP can’t express “next multiple of 50”; only powers of 10. CEILING.MATH adds a mode argument for handling negatives differently.
Microsoft Excel is a registered trademark of Microsoft Corporation. Google Sheets is a trademark of Google LLC. Formula Gym is not affiliated with, endorsed by, or sponsored by either company.