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

ArgumentRequired?What it does
numberYesThe value to round.
significanceYesThe multiple to round up to.

Examples

Example 1 — Shipping in packs of 6

Round order quantities up to whole packs.

B2fx=CEILING(A2, 6)
AB
1OrderedShipped
21012
31212
41318
=CEILING(A2, 6) Explain

Common mistakes

  • Negative numbers. A positive number with a negative significance returns #NUM!. CEILING.MATH avoids this.

Notes

Kyle Stott

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.