FLOOR (Primitive Spread Function) rounds a number down to the nearest multiple of a specified value. .

SYNTAX:

FLOOR(value1,vslue2)

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. 

EXAMPLES:

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