Rounds number down, toward zero, to the nearest multiple of significance.
Number—is the numeric value you want to round.
Significance—is the multiple to which you want to round.
- If either argument is nonnumeric, FLOOR returns the #VALUE! error value.
- If number and significance have different signs, FLOOR returns the #NUM! error value.
- Regardless of the sign of number, a value is rounded down when adjusted away from zero. If number is an exact multiple of significance, no rounding occurs.
FLOOR(2.5, 1) equals 2
FLOOR(-2.5, -2) equals -2
FLOOR(-2.5, 2) equals #NUM!
FLOOR(1.5, 0.1) equals 1.5
FLOOR(0.234, 0.01) equals 0.23