Rounds a number down to the nearest multiple of significance.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
FLOOR(number, significance)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)Ergebnis: 2
Rounds 2.5 down to the nearest multiple of 1.
=FLOOR(17, 5)Ergebnis: 15
Rounds 17 down to the nearest multiple of 5.
The function returns the number unchanged.
Yes, but the rounding behavior depends on the sign of the number and the significance.