How do I use CEILING in Excel?
Use CEILING when you want to round up to a chosen multiple. Enter Number, Significance in that order, then add optional arguments when needed.
Excel Function
CEILING
Rounds number up to nearest multiple.
CEILING(number, significance)Arguments
number
RequiredSpecify a single cell reference.
significance
RequiredEnter a numeric value.
Practice Preview
Use CEILING to return the result with these settings (Number: D2 (cell D2 (Amount in column D)), Significance: 10).
Example Table
| # | ASlip ID | BUnit Price | CQuantity | DAmount |
|---|---|---|---|---|
| 2 | S001 | 120.5 | 3 | 361.5 |
| 3 | S002 | 98.2 | 5 | 491 |
| 4 | S003 | 450.7 | 2 | 901.4 |
| 5 | S004 | 300.4 | 4 | 1201.6 |
| 6 | S005 | 150.9 | 6 | 905.4 |
| 7 | ||||
| 8 |
How to Use (Formula)
=CEILING(D2, 10)Result
370
Practice This Function
CEILING FAQ
Where can I practice CEILING?
Use the "Start Function Practice" button to jump straight into CEILING drills.
What arguments does CEILING use?
The main arguments are Number, Significance. Enter them in order.