Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inCEILING(number, significance)
Newer CEILING.MATH(number, [significance], [mode]) makes significance optional and handles negatives more predictably.
Google Sheets✔ Built inCEILING(value, [factor])
Airtable✔ Built inCEILING(value, [significance])
Notion≈ Workaroundceil(number / multiple) * multiple
Notion's ceil() only rounds to whole numbers, so divide by the multiple first.
Try CEILING with your own values
Result (as Excel & Google Sheets return it)
4.5
Your formula, ready to paste
Excel=CEILING(4.42, 0.25) open excel.new ↗
Google Sheets=CEILING(4.42, 0.25) open sheets.new ↗
AirtableCEILING(4.42, 0.25)
Notion
workaround
ceil(4.42 / 0.25) * 0.25

Arguments

ArgumentWhat it means
numberThe value to round.
significanceThe multiple to round up to, e.g. 0.05, 5 or 15.

Examples

FormulaResultWhyCopy
=CEILING(4.42, 0.25)4.5Next quarter.
=CEILING(23, 5)25Next multiple of 5.
=CEILING(A2, 1/96)Next 15 minutesRound a time up to the next quarter hour (1/96 of a day).
=CEILING(-2.5, 2)-2Negative 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.

Part of the Math & Rounding functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.