دالة Google Sheets

FLOOR

Rounds a number down to the nearest multiple of significance.

إنشاء صيغة بالذكاء الاصطناعي نفس الدالة في Excel

تعمل هذه الدالة في Google Sheets كما تعمل في 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.

المعاملات

numberمطلوبThe numeric value you want to round.
significanceمطلوبThe multiple to which you want to round.

أمثلة

=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.

الأسئلة الشائعة

What happens if the number is already a multiple of significance?

The function returns the number unchanged.

Can I use negative numbers with FLOOR?

Yes, but the rounding behavior depends on the sign of the number and the significance.

دوال ذات صلة

CEILING ROUND INT