learn microsoft excel

Convert function in Excel 2007

Home Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
About Us Free Ebook Offline Training Blog Interactive Training
Convert is a useful function in many areas and helps to convert numerical data from one measurement system into another. For example, the weatherman may like to convert temperatures in degrees Fahrenheit to temperatures in degrees Centigrade. Sometimes you may like to convert miles into metres or square feet into square metres. We may observe a weight in pounds and since you are using the metric system you may like to know the weight of the object in Kilograms. Convert can perform many more such conversions and thus provide help not only to the common man but also students, engineers, etc.

=CONVERT(2,"lbm","kg") - converts pounds to kilograms
=CONVERT(78,"F","C") - converts degrees Fahrenheit to degrees Centigrade
=CONVERT(2,"mi","km") - miles are converted to kilometres
=CONVERT(100,"J","cal") - Joules to calories
=CONVERT(5,"HP","W") - Horse Power to Watt



Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
About Us Free Ebook Offline Training Blog Interactive Training