FLOOR function
Summary
Rounds a number down, toward zero
Syntax
FLOOR(number, significance)
The FLOOR function syntax has the following arguments:
• Number Required. The numeric value you want to round.
• Significance Required. The multiple to which you want to round.
• Number Required. The numeric value you want to round.
• Significance Required. The multiple to which you want to round.
Example
=FLOOR(3.7,2)
=FLOOR(-2.5,-2)
=FLOOR(2.5,-2)
=FLOOR(1.58,0.1)
=FLOOR(0.234,0.01)
=FLOOR(-2.5,-2)
=FLOOR(2.5,-2)
=FLOOR(1.58,0.1)
=FLOOR(0.234,0.01)