دالة Google Sheets

FIXED

Rounds a number to a specified number of decimals and formats it as text with or without commas.

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

تعمل هذه الدالة في Google Sheets كما تعمل في Excel تمامًا — بالصياغة والوسائط نفسها.

الصيغة

FIXED(number, [decimals], [no_commas])

The FIXED function converts a numeric value into a text string using a fixed number of decimals. It allows you to control whether thousands separators are included in the final output.

المعاملات

numberمطلوبThe number you want to round and convert to text.
decimalsاختياريThe number of digits to the right of the decimal point; defaults to 2.
no_commasاختياريA logical value; if TRUE, commas are omitted from the result.

أمثلة

=FIXED(1234.567, 1)

النتيجة: "1,234.6"

Rounds the number to one decimal place and includes the comma separator.

=FIXED(1234.567, 0, TRUE)

النتيجة: "1235"

Rounds to the nearest whole number and removes the comma separator.

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

Does FIXED return a number or text?

It returns a text string, meaning you cannot perform mathematical calculations on the result directly.

دوال ذات صلة

TEXT ROUND VALUE