CEILING Function in Excel, Google Sheets, Airtable & Notion
CEILING rounds a number up to the nearest multiple of a significance you choose — for example up to the next 0.05 for prices or the next 15 for minutes.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | CEILING(number, significance)Newer CEILING.MATH(number, [significance], [mode]) makes significance optional and handles negatives more predictably. |
| Google Sheets | ✔ Built in | CEILING(value, [factor]) |
| Airtable | ✔ Built in | CEILING(value, [significance]) |
| Notion | ≈ Workaround | ceil(number / multiple) * multipleNotion's ceil() only rounds to whole numbers, so divide by the multiple first. |
| Excel | =CEILING(4.42, 0.25) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =CEILING(4.42, 0.25) | open sheets.new ↗ |
| Airtable | CEILING(4.42, 0.25) | |
| Notion workaround | ceil(4.42 / 0.25) * 0.25 |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
number | The value to round. |
significance | The multiple to round up to, e.g. 0.05, 5 or 15. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=CEILING(4.42, 0.25) | 4.5 | Next quarter. | |
=CEILING(23, 5) | 25 | Next multiple of 5. | |
=CEILING(A2, 1/96) | Next 15 minutes | Round a time up to the next quarter hour (1/96 of a day). | |
=CEILING(-2.5, 2) | -2 | Negative numbers round toward zero (toward +∞). |
Examples use Excel / Google Sheets syntax unless noted.
How CEILING works
CEILING is ideal for pricing (round up to the next 0.05 or 0.99 band), packaging (next full pallet of 40) and time billing (next 6 or 15 minutes). Unlike ROUNDUP, which works in decimal places, CEILING works with any step size.
Excel's original CEILING requires the number and significance to have compatible signs, and returns #NUM! for a positive number with a negative significance. CEILING.MATH (Excel) and Google Sheets' CEILING are more forgiving. If you just need a whole number, Notion's ceil() and Excel's CEILING.MATH(x) both round up to the next integer.
Frequently Asked Questions
- How do I round a time up to the next 15 minutes?
- Times are fractions of a day, so use
=CEILING(A2, "0:15")in Excel or=CEILING(A2, 1/96)in either Excel or Google Sheets.