Measurement Conversions in Excel

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Measurement Conversions in Excel

Need to convert measurements for international clients? Check here
http://www.versitas.com/blog/2011/09/12/a-few-excel-tips/
  • Total Hits: 16762

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 176 votes

  • Category: MS Excel/Functions

  • Submitted on: 2013-03-20 23:47:14

  • Submitted By: Donna Johnson

  • Set as Favorite

Description:

If you have ever had to convert miles to kilometers, inches to centimeters, or Fahrenheit degrees to Celsius degrees then Excel can help you, too.

1. For Excel 2007/2010 users, click the Office Button in 2007 (or File tab in 2010)
2. Click Excel Options button
3. Click Add-Ins on the left
4. Click on Analysis ToolPak from list
5. Make sure Excel Add-Ins is selected in the Manage box
6. Click Go. Click to put a check mark in the box next to Analysis ToolPak and then click OK to return to your worksheet.

Then, you can use the Excel functions to do the conversions. For example, if you want to convert 2 1/2 pounds to kilograms, use the following Excel function: =CONVERT(2.5, “lbm”, “kg”) Your answer should be 1.133981. To find the kilogram equivalent of 1 pound, just replace 2.5 in the formula with 1.0, which should yield a result of 0.453592.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 35.23%  62
 Two starsTwo star  Vote LeftVote MiddleVote Right 8.52%  15
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 10.8%  19
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 9.09%  16
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 36.36%  64

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.





Advertisements
Advertisements