Site icon ExcelNotes

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

Exit mobile version