ROUNDUP Function
Rounds a number up, away from zero.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Overview
ROUNDUP always rounds away from zero, whatever the next digit is: 2.01 becomes 3.
Use it whenever you can't have a part: boxes to ship, staff to roster, sheets of material to buy.
Syntax
=ROUNDUP(number, num_digits) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The number to round. |
| num_digits | Yes | Decimal places; 0 for whole numbers, negative for tens, hundreds… |
Examples
Example 1 — Boxes needed
Each box holds 12 units. Any leftover needs another box.
C2fx=ROUNDUP(B2/12, 0)
| A | B | C | |
|---|---|---|---|
| 1 | Order | Units | Boxes |
| 2 | 1001 | 30 | 3 |
| 3 | 1002 | 24 | 2 |
| 4 | 1003 | 49 | 5 |
=ROUNDUP(B2/12, 0) Explain
Common mistakes
- Negative numbers go further negative. ROUNDUP(−2.1, 0) is −3 (away from zero). Use CEILING.MATH if you want −2.
Notes
- Related functions: ROUNDDOWN, ROUND, CEILING.MATH.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.