Saturday, May 19, 2012

Excel's Convert Function

I frequent John Walkenbach's website The Spreadsheet Page (spreadsheetpage.com) and always learn something new.  Today I downloaded a workbook that lists all the functions in Excel 2007.  There are 340 functions in the list, most of which I've never used and CONVERT is one that I'd never used or even heard of.

The CONVERT function "Converts a number from one measurement system to another" and is listed in the Engineering Category of Functions.  Using this function you can easily convert miles to kilometers,  pounds to kilograms, degrees Celsius to degrees Fahrenheit and many others.

I've already found a practical use for this function.  Using it I found that a 1.5 Liter bottle of Bourbon contains 33.8 1.5 oz shots.

You can learn more about this function at
http://office.microsoft.com/client/helppreview.aspx?AssetID=HP100623111033&QueryID=03RAPgEGJ&respos=1&rt=2&ns=EXCEL&lcid=1033&pid=CH100645391033

Here's a link to the Microsoft Excel 2007 Help list of 2007 functions
http://office.microsoft.com/client/helppreview.aspx?AssetId=HA102775249990&lcid=1033&NS=EXCEL&Version=12&pid=CH010064502&CTT=4#BM1

No comments:

Post a Comment