The CONVERT function in Excel is used to convert a value from one measurement unit to another. It’s a handy tool for converting various types of units, such as length, volume, temperature, and more, directly in your Excel worksheet.
Syntax
CONVERT(number, from_unit, to_unit)
Arguments
| number | The value you want to convert. |
| from_unit | The current unit of measurement for the value. |
| to_unit | The unit of measurement to which you want to convert the value. |
How to use
To use the CONVERT function, follow this simple syntax:
|
1 |
=CONVERT(number, from_unit, to_unit) |
Here’s a practical example: let’s say you have a length in inches (from_unit) and you want to convert it to centimeters (to_unit). The formula would look like this:
|
1 |
=CONVERT(A1, "in", "cm") |
This will convert the value in cell A1 from inches to centimeters.
Optional: If you have a measurement that might be optional (for example, if you don’t always have a “from_unit”), you can enclose it in square brackets and specify that it’s optional in the explanation.
Now, let’s see a few examples of how you can use the CONVERT function:
|
1 2 3 |
=CONVERT(100, "mi", "km") ' Converts 100 miles to kilometers =CONVERT(32, "°F", "°C") ' Converts 32 degrees Fahrenheit to degrees Celsius =CONVERT(500, "gal", "L") ' Converts 500 gallons to liters |
These examples demonstrate how you can convert different units using the CONVERT function.
Additional Information
If you encounter unfamiliar units or terms, you can refer to external resources or websites for definitions and explanations.
