MathLevel: IntermediateAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Example 2
- Related functions
CEILING rounds up to the nearest multiple — prices ending in 5 or 9, pack sizes. CEILING.MATH is the newer version that handles negatives more simply.
Syntax
=CEILING(number, significance)
| Argument |
What it means |
significance |
The multiple. |
Examples
Example 1
=CEILING(123, 5)
Returns 125.
Example 2
=CEILING(A2, 10) - 1
Round a price up to the next …9.
CEILING.MATH · FLOOR · MROUND
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong