# CEILING function in Excel

> CEILING rounds a number up to the next multiple you choose: the next 5, the next dozen, the next quarter hour.

Source: https://spreadsheetpractice.com/functions/ceiling · 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:** CEILING rounds a number up to the next multiple you choose: the next 5, the next dozen, the next quarter hour.
- **Syntax:** `=CEILING(number, [significance])`
- **Most common use:** `=CEILING(B2,5)` returns 25 (Up to the next multiple of 5: 23 becomes 25)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The smallest multiple of significance that is at least number. Negative numbers round up toward zero.

## What it does

CEILING rounds a number up to the next multiple you choose: the next 5, the next dozen, the next quarter hour. Use it for order quantities that come in packs, prices that end on a set step, or time billed in blocks.

## Syntax

`=CEILING(number, [significance])`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The value to round up. |
| `significance` | Optional | The multiple to round up to, such as 5, 12 or 0.25. Excel requires it in CEILING; CEILING.MATH makes it optional. |

## Examples

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

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=CEILING(B2,5)` | 25 | Up to the next multiple of 5: 23 becomes 25 |
| D3 | `=CEILING(B3,0.25)` | 4.25 | Up to the next quarter: 4.12 hours becomes 4.25 |
| D4 | `=CEILING(B4,2)` | -2 | For a negative number, rounding up moves toward zero: -2.5 becomes -2 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Item | Amount |  | Rounded up |
| 2 | Shipping weight (lb) | 23 |  | 25 |
| 3 | Labor hours | 4.12 |  | 4.25 |
| 4 | Credit | -2.5 |  | -2 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #NUM! | number is positive but significance is negative, such as =CEILING(2.5,-2). Use a positive significance. |
| Excel says too few arguments | CEILING needs significance. Use =CEILING(A2,1) for whole numbers, or CEILING.MATH(A2), where it's optional. |
| Wanted the nearest multiple, not the next one up | CEILING always goes up. Use MROUND to round to whichever multiple is closer. |

## Tips

- Packs of different sizes? Point significance at a cell: =CEILING(B2,C2) rounds each quantity up to its own pack size.

## Related functions

- [FLOOR](https://spreadsheetpractice.com/functions/floor): FLOOR rounds a number down to the previous multiple you choose: down to the nearest 10, the nearest quarter, or the start of a price band.
- [ROUNDUP](https://spreadsheetpractice.com/functions/roundup): ROUNDUP always rounds away from zero, whatever the next digit is.
- [MROUND](https://spreadsheetpractice.com/functions/mround): MROUND rounds a number to the nearest multiple of another number.

## Questions

### How do I round up to the nearest 0.5 in Excel?

Use =CEILING(A2,0.5). 3.1 becomes 3.5 and 3.6 becomes 4.

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

ROUNDUP rounds to decimal places or powers of ten. CEILING rounds up to any multiple, such as 5 or 12.

### What is CEILING.MATH?

A newer version (Excel 2013 and later) where significance is optional and a third argument controls how negative numbers round.

## Practice

A graded CEILING exercise ("Order in full packs") is on [the CEILING page](https://spreadsheetpractice.com/functions/ceiling). It is checked instantly, then re-checked on changed data.

---

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