Rounds a number down to the nearest multiple of significance.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
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)結果: 2
Rounds 2.5 down to the nearest multiple of 1.
=FLOOR(17, 5)結果: 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.