|

How To Use The CONVERT Function to Translate Between Different Units

Do you ever need to convert between different measurement systems?  It’s more of a problem in the US, where the last Imperialists stubbornly cling to archaic units in the face of the rest of the world metricating. They inflict units like ounces, gallons, acres, feet and inches on us.  What are they talking about?

Never stress, though, Excel can help.  The CONVERT Function can do a large number of conversions for you.  For example:

DescriptionValueFormula
1 mile in km1.609344=CONVERT(1,”mi”,”km”)
1 mile in metres1609.344=CONVERT(1,”mi”,”m”)
1 pint in litres       0.473=CONVERT(1,”pt”,”l”)
1 cup in litres       0.237=CONVERT(1,”cup”,”l”)
1 ounce mass in grams     28.350=CONVERT(1,”ozm”,”g”)
1 International acre in ha     0.4047=CONVERT(1,”uk_acre”,”ha”)
1 parsec in light-years     3.2616=CONVERT(1,”parsec”,”ly”)
1 parsec in km3.086E+13=CONVERT(1,”parsec”,”km”)

To see the full list of abbreviations (some of which will show up as you type the formula), visit this page of Microsoft Help.  That page is also interesting for the list of unit prefixes near the end, like yotta (10^24), zetta (10^21), femto, atto, and zepto!  The Wikipedia page “Orders of Magnitude” is also interesting in this regard.

Similar Posts