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.