FLOOR
Description
Rounds a number down to the nearest integer, based on the specified significance.
Syntax
FLOOR(
number
,
significance
)
- number: The number to round.
- significance: The multiple of significance to round the number down to. The default is 1, which causes the number to be rounded down to the next smaller integer.
Example
Formula | Result |
|---|---|
=FLOOR(12.34,1) | 12 |
=FLOOR(12.34,10) | 10 |
=FLOOR(12.34,2) | 12 |
=FLOOR(-12.34,2) | -14 |
=FLOOR(-12.34,-1) | -12 |