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