CEILING and FLOOR Function Generator
CEILING rounds up to the nearest multiple of a given number; FLOOR rounds down. Ideal for pricing tiers, time slot bucketing, inventory pack sizes.
Syntax
=CEILING(number, significance) or =FLOOR(number, significance)Try it — generate a CEILING / FLOOR formula
Examples
Round up to nearest 5
=CEILING(A2, 5)37 becomes 40; 41 becomes 45.
Price floor of $0.99
=FLOOR(A2, 0.99)Rounds price down to the nearest 99¢.
15-minute time slots
=CEILING(A2, TIME(0,15,0))Rounds up a time to the next quarter hour.
Tips
- ✓ROUND rounds to nearest — CEILING always up, FLOOR always down.
- ✓Use MROUND to round to nearest multiple (up or down).
- ✓In Sheets, CEILING.MATH gives more control over negative numbers.
Related Formulas
ROUND / ROUNDUP / ROUNDDOWN
Three rounding functions: ROUND (nearest), ROUNDUP (always up), ROUNDDOWN (alway...
MOD
MOD returns the remainder after one number is divided by another. Common uses: a...
POWER
POWER raises a number to the power of an exponent. Equivalent to using ^ but mor...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free