دالة Google Sheets

CONVERT

Converts a number from one measurement system to another.

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

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

الصيغة

CONVERT(number, from_unit, to_unit)

The CONVERT function allows you to translate values between different units of measurement, such as weight, distance, time, pressure, or temperature. It is highly useful for standardizing data sets that contain mixed units.

المعاملات

numberمطلوبThe numeric value in from_unit that you want to convert.
from_unitمطلوبThe unit for the number.
to_unitمطلوبThe unit for the result.

أمثلة

=CONVERT(10, "m", "ft")

النتيجة: 32.80839895

Converts 10 meters into feet.

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

Are unit abbreviations case-sensitive?

Yes, unit abbreviations are case-sensitive; for example, 'm' represents meters while 'M' represents miles.

دوال ذات صلة

ROUND ABS