How to Use FLOOR Function

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.

Download: FLOOR Function

Leave a Reply