CONVERT function 094 دالة CONVERT فى اكسل بالتفصيل

-1-

-2-

 CONVERT function    094    دالة  CONVERT   فى اكسل بالتفصيل

 استخدام دالة CONVERT لتحويل العملات والوحدات القياسية. على سبيل المثال، تُحول الصيغة التالية 100 دولار أمريكي إلى يورو:

=CONVERT(100, "USD", "EUR")

ستعيد هذه الصيغة القيمة 91.10 يورو.

تُحول الصيغة التالية 100 متر إلى كيلومترات:

=CONVERT(100, "m", "km")

ستعيد هذه الصيغة القيمة 0.1 كيلومترات.

تعد دالة CONVERT أداة قوية يمكن استخدامها لتحويل البيانات إلى مجموعة متنوعة من التنسيقات المختلفة. إنها أداة مفيدة لأي شخص يعمل مع البيانات بشكل منتظم.

لتحويل الوحدات القياسية من إنش إلى سنتيمتر، استخدم الرمز التالي:

=CONVERT(A1, "in", "cm")

https://support.microsoft.com/ar-sa/office/convert-%D8%A7%D9%84%D8%AF%D8%A7%D9%84%D8%A9-convert-d785bef1-808e-4aac-bdcd-666c810f9af2

The CONVERT function can also be used to convert currencies and units of measurement. For example, the following formula converts 100 US dollars to euros:

=CONVERT(100, "USD", "EUR")

This formula will return the value 91.10 euros.

The following formula converts 100 meters to kilometers:

=CONVERT(100, "m", "km")

This formula will return the value 0.1 kilometers.

The CONVERT function is a powerful tool that can be used to convert data to a variety of different formats. It is a useful tool for anyone who works with data on a regular basis.

    Formula  Description   Result

----------------------------------------------------

=CONVERT(1, "lbm", "kg")

Converts 1 pound mass to kilograms.

0.4535924

-------------------------------------------------------------

=CONVERT(68, "F", "C")

Converts 68 degrees Fahrenheit to Celsius.

20

----------------------------------------------------------

=CONVERT(2.5, "ft", "sec")

Data types are not the same, so an error is returned.

#N/A

------------------------------------------------------------------

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

Converts 100 square feet into square meters.

9.290304

-------------------------------------------------------------------

You can see how CONVERT works in Excel. Copy the following table (starting with the "6") and paste it to a blank Excel worksheet, placing the "6" in cell A1.

6

  Formula   Description (Result)

==============================

=CONVERT(A1,"C","F")

Convert 6 degrees Celsius to Fahrenheit (42.8)

=======================================

=CONVERT(A1,"tsp","tbs")

Convert 6 teaspoons to tablespoons (2)

========================================

=CONVERT(A1,"gal","l")

Convert 6 gallons to liters (22.71741274)

====================================

=CONVERT(A1,"mi","km")

Convert 6 miles to kilometers (9.656064)

===========================================

=CONVERT(A1,"km","mi")

Convert 6 kilometers to miles (3.728227153)

============================================

=CONVERT(A1,"in","ft")

Convert 6 inches to feet (0.5)

===================================

=CONVERT(A1,"cm","in")

Convert 6 centimeters to inches (2.362204724)

============================================

following formula:

=CONVERT(100, "m", "km")

This formula will return the value 0.1 kilometers.

-------------------------------------------------

Here are some more examples of how to use the CONVERT function to convert units in Excel:

------------------------------------

To convert 100 feet to inches, use the following formula:

=CONVERT(100, "ft", "in")

This formula will return the value 1200 inches.

--------------------------------------------

To convert 100 pounds to kilograms, use the following formula:

=CONVERT(100, "lb", "kg")

This formula will return the value 45.36 kilograms.

-----------------------------------------------

To convert 100 degrees Celsius to degrees Fahrenheit, use the following formula:

=CONVERT(100, "C", "F")

This formula will return the value 212 degrees Fahrenheit.

--------------------------------------------------------

You can also use the CONVERT function to convert units of time. For example, to convert 100 seconds to minutes, you would use the following formula:

=CONVERT(100, "s", "m")

This formula will return the value 1.67 minutes.

----------------------------------

ملف العمل  

-3-

-4-