Rounds a number down to the nearest integer or to the nearest multiple of significance.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-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.