Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
CEILING
CEILING always rounds a number up (away from zero) to the nearest multiple of the significance you specify. It is ideal for ensuring you never underestimate quantities, such as rounding up hours worked or package quantities to whole units.
Excel
=CEILING(A2,1)Google Sheets
=CEILING(A2,1)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Hours | Billed |
| 3.2 | |
| 7.05 | |
| 1.8 | |
| 5.0 |
=CEILING(A2,1)→4
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2 is the value to round up (e.g. 3.2 hours worked).
- 21 is the significance — results will be multiples of this value.
- 3CEILING always rounds away from zero, so 3.2 becomes 4 and -3.2 becomes -3.