Syntax
FLOOR(number, significance)
| Parameter | Description |
|---|---|
| number | Parameter of the FLOOR function. |
| significance | Parameter of the FLOOR function. |
Examples
Round to nearest quarter
Formula
=FLOOR(7.68, 0.25)
Returns 7.50. Rounds $7.68 down to the nearest 25-cent increment.
Time billing in 15-min blocks
Formula
=FLOOR(2.33, 0.25)
Returns 2.25. If 2.33 hours were worked, billing in 15-minute increments gives 2 hours 15 minutes.
Round to nearest 50
Formula
=FLOOR(1234, 50)
Returns 1200. The nearest multiple of 50 that doesn't exceed 1234.
Common Errors
#NUM!
Number and significance must have the same sign. FLOOR(-5, 2) returns #NUM! because a negative number with a positive significance is invalid. Use FLOOR.MATH instead.
#DIV/0!
Significance of 0 causes division by zero: =FLOOR(10, 0) returns #DIV/0!.
Tips
Negative numbers are tricky
FLOOR requires the number and significance to have the same sign. For negative numbers, use FLOOR.MATH which handles them more intuitively.
Common multiples
Pricing: 0.05 or 0.25. Time: 0.25 (15 min) or 0.5 (30 min). Inventory: 6, 12, or 24 (pack sizes).
Pair with CEILING
FLOOR rounds down to a multiple, CEILING rounds up. Use both to create price ranges: the item costs between FLOOR(x,0.25) and CEILING(x,0.25).
Try FLOOR in Viztab
Import your data and use FLOOR with 370+ other formulas. No signup required.
Open Viztab