CEILING Function
Rounds a number up to the nearest multiple of significance.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Want to practice CEILING in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
CEILING rounds up to the next multiple you choose — the next 5, the next 0.99 price point, the next full pack.
It's the original version, kept for compatibility. Newer workbooks should use CEILING.MATH, which handles negative numbers more predictably.
Syntax
=CEILING(number, significance) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The value to round. |
| significance | Yes | The multiple to round up to. |
Examples
Example 1 — Shipping in packs of 6
Round order quantities up to whole packs.
B2fx=CEILING(A2, 6)
| A | B | |
|---|---|---|
| 1 | Ordered | Shipped |
| 2 | 10 | 12 |
| 3 | 12 | 12 |
| 4 | 13 | 18 |
=CEILING(A2, 6) Explain
Common mistakes
- Negative numbers. A positive number with a negative significance returns #NUM!. CEILING.MATH avoids this.
Notes
- Related functions: CEILING.MATH, CEILING.PRECISE, FLOOR.MATH, ROUNDUP.

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.