# ROUNDUP function in Excel

> ROUNDUP always rounds away from zero, whatever the next digit is.

Source: https://spreadsheetpractice.com/functions/roundup · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** ROUNDUP always rounds away from zero, whatever the next digit is.
- **Syntax:** `=ROUNDUP(number, num_digits)`
- **Most common use:** `=ROUNDUP(B2/C2,0)` returns 6 (130 units need 5.4 boxes, so 6 boxes)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The number rounded away from zero to the digits you chose.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

ROUNDUP always rounds away from zero, whatever the next digit is. Use it whenever coming up short isn't an option: boxes needed for an order, staff needed for a shift, or a price that must cover its cost.

## Syntax

`=ROUNDUP(number, num_digits)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The number or calculation to round up. |
| `num_digits` | Required | How many digits to keep: 0 for whole numbers, 1 for one decimal, -1 for the next ten. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=ROUNDUP(B2/C2,0)` | 6 | 130 units need 5.4 boxes, so 6 boxes |
| D3 | `=ROUNDUP(B3/C3,0)` | 2 | An exact result stays as it is: 2 boxes |
| D5 | `=ROUNDUP(1234.5,-2)` | 1300 | Negative digits round up to the next hundred |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Order | Units | Per box | Boxes |
| 2 | A-1 | 130 | 24 | 6 |
| 3 | A-2 | 48 | 24 | 2 |
| 4 | A-3 | 7 | 12 |  |
| 5 |  |  |  | 1300 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Negative numbers get more negative | ROUNDUP rounds away from zero, so -2.1 becomes -3. To round toward positive infinity, use CEILING(A2,1), which turns -2.1 into -2. |
| Excel says too few arguments | num_digits is required. Use 0 for whole numbers. |
| Rounded the wrong step | Round the final quantity, not the inputs: =ROUNDUP(B2/C2,0) gives boxes needed, while =ROUNDUP(B2,0)/C2 still leaves a fraction. |

## Tips

- To round up to a multiple other than 10, 100 and so on, such as packs of 6, use CEILING(A2,6).

## Related functions

- [ROUND](https://spreadsheetpractice.com/functions/round): ROUND rounds a number to the number of digits you choose.
- [ROUNDDOWN](https://spreadsheetpractice.com/functions/rounddown): ROUNDDOWN always rounds toward zero, dropping the extra digits whatever they are.
- [CEILING](https://spreadsheetpractice.com/functions/ceiling): CEILING rounds a number up to the next multiple you choose: the next 5, the next dozen, the next quarter hour.
- Comparison: [ROUND vs ROUNDUP vs ROUNDDOWN](https://spreadsheetpractice.com/functions/compare/round-vs-roundup-vs-rounddown)

## Questions

### How do I always round up in Excel?

Use =ROUNDUP(A2,0) for whole numbers or =ROUNDUP(A2,2) for cents. It rounds up even when the next digit is 1.

### How do I round up to the nearest 10?

Use =ROUNDUP(A2,-1), or =CEILING(A2,10).

### What is the difference between ROUNDUP and CEILING?

ROUNDUP works in powers of ten (decimals, tens, hundreds). CEILING rounds up to any multiple you name, such as 5, 12 or 0.25.

## Practice

A graded ROUNDUP exercise ("Quarter hired") is on [the ROUNDUP page](https://spreadsheetpractice.com/functions/roundup). It is checked instantly, then re-checked on changed data.

Lessons that use ROUNDUP:

- [Lesson 25: Tenure, quarters & weekdays](https://spreadsheetpractice.com/learn/tenure-quarters-weekdays) (Pro)
- [Lesson 33: ROUND, ROUNDUP & ROUNDDOWN](https://spreadsheetpractice.com/learn/round-roundup-rounddown) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
