Math
FLOOR
Definition
FLOOR returns a number rounded down, toward zero, to the next multiple of a given significance.
Syntax
=FLOOR(number, significance)
Arguments
| Argument | Meaning |
|---|---|
number |
The value to round, or the cell holding it. |
significance |
The multiple to round to, such as 1 or 5. |
Worked example
A mill sells grain only in 5 kg steps, so each weigh-in is dropped to the multiple of 5 below. Weights are in A2:A4.
| A: Weight |
|---|
| 23 |
| 20 |
| 11 |
Formula: =FLOOR(A2,5)
Result: 20. 23 sits between 20 and 25, so FLOOR drops it to 20. Filled down, the formula gives 20, 20, and 10.
Practice
Cell A2 holds 12.7. In B2, write a formula that rounds it down to the next multiple of 1.
- In B2, write a FLOOR formula that rounds A2 down to a multiple of 1.
- B2 should show A2 rounded down to a multiple of 1.
Step 1 of 2
Enter =FLOOR(A2,1) in B2.
A2 is 12.7, so rounding down to a multiple of 1 gives 12.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses FLOOR.
B2 now shows 12.
Related functions
ROUND can go up or down by digit. ABS drops a sign; it does not drop to a multiple.
Common mistake
Omitting significance, as in =FLOOR(A2): FLOOR needs the multiple as the second argument.