FLOOR
Rounds a number down, toward zero.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Rounds a number down to the nearest multiple of significance (Legacy).
Syntax
FLOOR(number, significance)
Arguments
number(number) — Number to round.significance(number) — Multiple to round to.
Examples
Floor Rounding
Round 2.5 down to nearest 1.
FORMULA
=FLOOR(2.5, 1)
RESULT
2
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Val | Sig |
| 2 | 2.5 | 1 |