CONVERT

 The CONVERT function in Excel is a powerful tool that allows you to convert a number from one measurement system to another. It supports a wide range of units across different categories such as weight, distance, time, pressure, force, energy, power, magnetism, temperature, volume, area, information, and speed.

Here’s a detailed explanation of the CONVERT function, including its syntax, supported units, and examples:

Syntax

excel

Copy

CONVERT(number, from_unit, to_unit)

• number: The value you want to convert.

• from_unit: The unit of the number you are converting from.

• to_unit: The unit you want to convert to.

Supported Units

The CONVERT function supports a wide range of units. Here are some of the categories and their respective units:

1. Weight and Mass

   • "g" (gram)

   • "kg" (kilogram)

   • "lbm" (pound mass)

   • "ozm" (ounce mass)

2. Distance

   • "m" (meter)

   • "mi" (mile)

   • "km" (kilometer)

   • "in" (inch)

   • "ft" (foot)

   • "yd" (yard)

3. Time

   • "yr" (year)

   • "day" (day)

   • "hr" (hour)

   • "mn" (minute)

   • "sec" (second)

4. Pressure

   • "Pa" (Pascal)

   • "atm" (atmosphere)

   • "mmHg" (millimeters of mercury)

5. Force

   • "N" (Newton)

   • "dyn" (dyne)

   • "lbf" (pound-force)

6. Energy

   • "J" (Joule)

   • "eV" (electron volt)

   • "cal" (calorie)

   • "BTU" (British Thermal Unit)

7. Power

   • "W" (Watt)

   • "hp" (horsepower)

8. Magnetism

   • "T" (Tesla)

   • "ga" (Gauss)

9. Temperature

   • "C" (Celsius)

   • "F" (Fahrenheit)

   • "K" (Kelvin)

10. Volume

    • "l" (liter)

    • "tsp" (teaspoon)

    • "tbsp" (tablespoon)

    • "gal" (gallon)

11. Area

    • "m^2" (square meter)

    • "in^2" (square inch)

    • "ft^2" (square foot)

    • "yd^2" (square yard)

12. Information

    • "bit" (bit)

    • "byte" (byte)

13. Speed

    • "m/s" (meters per second)

    • "km/h" (kilometers per hour)

    • "mph" (miles per hour)

    • "kn" (knot)

Examples

1. Convert 100 grams to kilograms:

   excel

   Copy

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

   Result: 0.1

2. Convert 5 miles to kilometers:

   excel

   Copy

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

   Result: 8.04672

3. Convert 32 degrees Fahrenheit to Celsius:

   excel

   Copy

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

   Result: 0

4. Convert 1000 watts to horsepower:

   excel

   Copy

   =CONVERT(1000, "W", "hp")

   Result: 1.34102

5. Convert 2 liters to gallons:

   excel

   Copy

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

   Result: 0.528344

Notes

• Ensure that the units you are converting between are compatible (e.g., you cannot convert grams to meters).

• The CONVERT function is case-insensitive, so "kg" and "KG" are treated the same.

• If you attempt to convert between incompatible units, Excel will return an error (#N/A).

Advanced Usage

You can also use the CONVERT function in combination with other Excel functions for more complex calculations. For example, you might want to convert a range of values and then sum them up:

excel

Copy

=SUM(CONVERT(A1:A10, "mi", "km"))

This formula converts all values in the range A1:A10 from miles to kilometers and then sums the results.

Conclusion

The CONVERT function is a versatile tool in Excel that can handle a wide variety of unit conversions. By understanding its syntax and the units it supports, you can efficiently perform conversions in your spreadsheets, saving time and reducing the potential for errors.