Excel 2007 CONVERT Function

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.

Read Excel's help file on the CONVERT function to see a complete list of units that can be used with this function.

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:

Note: For help with this example, see the image to the right.

In this example, we will convert 30 degrees Celsius to degrees Fahrenheit.

1. Enter the following data into cell D1: 30
   
   
2. Enter the following data into cell D2: cel
   
   
3. Enter the following data into cell D3: fah
   
   
4. Click on cell D4 in the spreadsheet - this is where the function will be located.
   
   
5. Click on the Formulas tab of the ribbon menu.
   
   
6. Choose More Functions > Engineering from the ribbon to open the function drop down list.
   
   
7. Click on CONVERT in the list to bring up the function's dialog box.
   
   
8. In the dialog box, click on the Number line.
   
   
9. Click on cell D1 in the spreadsheet.
   
   
10. In the dialog box, click on the From_Unit line.
    
    
11. Click on cell D2 in the spreadsheet.
    
    
12. In the dialog box, click on the To_Unit line.
    
    
13. Click on cell D3 in the spreadsheet.
    
    
14. Click OK.
    
    
15. The answer 172 should appear in cell D4.

• Excel Functions
• Excel MAX Function
• Excel MIN Function