Rounds a number down to the nearest integer or to the nearest multiple of significance.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
FLOOR.MATH(number, [significance], [mode])The FLOOR.MATH function rounds a number down toward zero or away from zero, depending on the mode. It is more flexible than the standard FLOOR function because it allows you to control the rounding direction for negative numbers.
=FLOOR.MATH(6.7)結果: 6
Rounds 6.7 down to the nearest integer.
=FLOOR.MATH(-5.2, 2)結果: -6
Rounds -5.2 down to the nearest multiple of 2.
FLOOR.MATH provides a mode argument to control how negative numbers are rounded, whereas FLOOR does not.