The CONVERT function is used to convert data from one set of units to another.
For example, the CONVERT function can be used to convert miles to kilometers, hours to minutes, or degrees Celsius to degrees Fahrenheit.
All of the units and their shortforms that can be used with this function are available in this list.
The syntax for the CONVERT function is:
=CONVERT ( Number, From_Unit, To_Unit )
Number - the value to be converted.
From_Unit - the number's current measurement unit.
To_Unit - the measurement unit the number will be converted to.
Example Using Excel's CONVERT Function:
For help with this example, see the image above.
In this example, we will convert 30 degrees Celsius to degrees Fahrenheit.
- Enter the following data into cell D1: 30
- Enter the following data into cell D2: cel
- Enter the following data into cell D3: fah
- Click on cell D4 in the worksheet - this is where the function will be located.
- Click on the Formulas tab of the ribbon menu.
- Choose More Functions > Engineering from the ribbon to open the function drop down list.<
- Click on CONVERT in the list to bring up the function's dialog box.
- In the dialog box, click on the Number line.<
- Click on cell D1 in the worksheet.
- In the dialog box, click on the From_Unit line.
- Click on cell D2 in the worksheet.
- In the dialog box, click on the To_Unit line.
- Click on cell D3 in the worksheet.
- Click OK.
- The answer 86 should appear in cell D4.
- When you click on cell D4 the complete function =CONVERT( D1, D2, D3) appears in the formula bar above the worksheet.