The FLOOR function rounds a number down to the nearest multiple of significance toward zero.
Formula:
=FLOOR(number, significance)
Explanations:
– The number is required, which is a number that needs to round.
– Significance is required, the multiple to which you need to round.
Cautions:
– If the sign of the number is positive, a value is rounded down toward zero.
– If the sign of the number is negative, a value is rounded down away from zero.
– If the number is an exact multiple of significance, no rounding occurs.