FLOOR Function

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

Syntax

FLOOR(number, multiple )

Parameters

Name	Required/Optional	Data Type	Description
number	Required	Number	The number to round.
multiple	Required	Number	The multiple to which to round.

Return value

Number

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.