These docs are for v1.0. Click to read the latest docs for v1.2.

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

ArgumentTypeDescription
valueNumberThe value to round down
factorNumber(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