EXCEL: Using Convert Formula

Leave a comment

To convert miles to kilometers:

  1. Select cell E5 and type =CONVERT(. or Click on Formulas Tab, More Functions, Engineering, Convert)
  2. Click the Paste Function button to access the Function Arguments window.
  3. Select cell D5, which holds the value you wish to convert, so the cell reference appears in the Number text box.
  4. Press [Tab] and enter mi in the From_Unit text box.
  5. Press [Tab], enter km in the To_Unit text box, and click OK.
  6. Select cell E5 and drag its fill handle down to cell E9 to apply the formula to the other cells.
  7. Select the range E5:E9 and click the Decrease Decimal button on the Formatting toolbar until the values display in tenths of a kilometer.

The CONVERT function also converts units of measurement for mass, pressure, liquid, and many others. For a complete list, along with the unit abbreviations accepted by the function, type CONVERT in Excel’s Help window.

Once you create a worksheet based on our example, you can use the CONVERT function to instantly perform the conversions from miles to kilometers.

Advertisements

EXCEl: 300 Formula Examples

2 Comments

I was teaching my Computer Literacy class and the students wanted me to give examples of different formulas. ¬†Thank goodness for the internet because I found a site that¬†links to over 300 Excel formula examples. This site created by EXCELJET.com allows you to click on a formula for a full description as well as an excel example. Related functions appear to the right and are also clickable. Also click “list of Excel functions” to see the list of functions. You can also search for a function as well. Here is the URL for you to copy and paste in your browser:

https://exceljet.net/formulas

exceljet