FLOOR

Name

Floor

Description

Rounds a number down to the nearest multiple of a specified value.

Syntax

FLOOR(value1, value2)

Remarks

Specify the number to round using the value1 argument. Specify the value to use as the rounding factor using the value2 argument. Use either both positive or both negative numbers for the arguments. Regardless of the sign of number, the number is rounded toward zero.

See also CEILING, EVEN, INT, ODD, ROUND, ROUNDDOWN, ROUNDUP, and TRUNC.

Data Type

Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

FLOOR(R1C2,1)
FLOOR(C4,B2)
FLOOR(B3,0.05)
FLOOR(4.65,2)=4
FLOOR(-2.78,-1)=-2