Rounds a number down to the nearest multiple of significance.
Sintassi
FLOOR(number, significance)Argomenti
numberobbligatorio
The numeric value you want to round.
significanceobbligatorio
The multiple to which you want to round.
The FLOOR function rounds a number down, toward zero, to the nearest multiple of the specified significance. It is commonly used for rounding prices or quantities to a specific increment.
=FLOOR(2.5, 1)→2Rounds 2.5 down to the nearest multiple of 1.
=FLOOR(17, 5)→15Rounds 17 down to the nearest multiple of 5.
Select the cell
Click on the cell where you want the result to appear.
Enter the function
Type =FLOOR( followed by the number and the significance, then close the parenthesis.
Press Enter
Press Enter to calculate the rounded value.
The function returns the number unchanged.
Yes, but the rounding behavior depends on the sign of the number and the significance.