CONVERT formula in Excel with examples

The CONVERT function in Excel allows you to convert a value from one measurement system to another. Here’s how it works:

1. Syntax:

   CONVERT(number, from_unit, to_unit)
   

   • number: The value you want to convert.
   • from_unit: The units for the input value.
   • to_unit: The units for the result.

2. Measurement Systems: The CONVERT function accepts various text values (in quotation marks) for from_unit and to_unit. These include:

   • Length: "mi" (miles), "km" (kilometers), "yd" (yards), "m" (meters), etc.
   • Temperature: "C" (Celsius), "F" (Fahrenheit), "K" (Kelvin).
   • Mass: "lbm" (pounds), "kg" (kilograms), "ozm" (ounces), etc.

3. Examples:

   • To convert 1 mile to kilometers: =CONVERT(1, "mi", "km") (result: 1.609 kilometers).
   • To convert 12 inches to centimeters: =CONVERT(12, "in", "cm") (result: 30.48 centimeters).

Remember to adjust the function based on your specific conversion needs!