The FLOOR function rounds a number downwards to the nearest multiple of significance.
Examples:
FLOOR(3.657, 1) returns 3 (downwards to nearest whole number)
FLOOR(5.5, 2) returns 4 (nearest number divisible by 2)
Note that the sign of both parameters must be the same, so FLOOR(-5.5, 2) returns #VALUE while FLOOR(-5.5, -2) returns -4.
FLOOR is complemented by CEILING(number, significance)
See also: