Loading…
Loading…
CEILING rounds up to the next multiple of a number and FLOOR rounds down to the previous one. Use them for pricing steps (0.50), time blocks (15 minutes) or pack sizes (12 per box). Excel 2013+ also has CEILING.MATH and FLOOR.MATH, which handle negative numbers more predictably.
Syntax
CEILING(number, significance) · FLOOR(number, significance)
Example: =CEILING(47,15) returns 60. =FLOOR(62,12) returns 60.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.