FLOOR
Rounds a number down, toward zero. Replaced by FLOOR.MATH.
Syntax
FLOOR(number, significance)
Parameters
- number: Required. The numeric value you want to round
- significance: Required. The multiple to which you want to round
Example
=FLOOR(2.5, 1)