FLOOR
Rounds down (to a lesser absolute value) to the nearest multiple of the specified factor. Defaults to a factor of 1.
Syntax
=FLOOR(value, factor)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Number | The value to round down |
| factor | Number | (Optional) Specified factor |
Examples
=FLOOR(3.14)→3
Rounds the value 3.14 down to the nearest multiple of 1
=FLOOR(10, 4)→8
Rounds the value 10 down to the nearest multiple of 4
=FLOOR(-10, 4)→-8
Rounds the value -10 down to the nearest multiple of 4
Updated 10 months ago