FLOOR(number, significance)

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:

Other mathematical functions