FLOOR function

See also

Rounds a number toward 0 (zero), to the next integer, or to the next instance of multiple.

Syntax

FLOOR(number, multiple)

Remarks

If multiple is not specified, the number rounds toward 0 to the next integer.

Number and multiple must have the same signs or a #NUM! error is returned. If either number or multiple cannot be converted to a value, a #VALUE! error is returned. If either number or multiple is 0, the result is 0.

Example 1

FLOOR(3.7)

Returns 3.

Example 2

FLOOR(-3.7)

Returns -3.

Example 3

FLOOR(3.7, 0.5)

Returns 3.5.