"Excel 2010 Functions: The Advantages of Using Functions in your Formulas"
Introduction to Excel 2010 Functions
A function is a built-in tool that you use in a formula. In other words, it's a predefined formula that performs a specific task.
Worksheet functions allow you to perform calculations or operations that would otherwise be impossible. A typical function (such as SUM) takes one or more arguments and then returns a result. The SUM function, for example, accepts a range argument and then returns the sum of the values in that range (see demonstrations below).
Because of this, you need to understand the advantages of using functions, and you need to know the basic structure of every function. This is what we will covers in this tutorial.
You'll find functions useful because they:
Let see it with real-life examples.
For example, you might need to calculate the total of the values in 10 cells (B1:B10). Without the help of any functions, you would need to construct a formula like this:
No doubt that you can get the end result correct. But how about if you need to calculate the total values in cells B1 to B50? Even worse, you would need to edit this formula if you inserted a new row in the B1:B10 range and needed the new value to be included in the total.
However, you can replace the above formula with a much simpler one that uses the SUM function:
For example, you need to determine the smallest value in a range. A formula can't tell you the answer without using a function. This formula uses the MIN function to return the smallest value in the range A1:C50:
Assume that you have a worksheet that contains 500 names in cells A1:A500 and that all the names appear in all-uppercase letters. You has been asked to convert all the names to the lowercase!! For example, JOHN SMITH must change to John Smith.
You can use the function such as the following, which uses the PROPER function to convert the text in cell A1 to proper case:
Bingo! You just eliminated several hours of tedious work in less than a minute.
Suppose that you need to calculates sales commissions. If a salesperson sells at least $10,000 of product, the commission rate reaches 10 percent; otherwise, the commission rate remains at 5.0 percent.
Here you can uses the IF function to check the value in cell C1 and make the appropriate commission calculation:
The formula is making a decision: If the value in cell C1 is less than 10,000, then return the value in cell C1 multiplied by 5 percent. Otherwise, return the value in cell C1 multiplied by 10 percent.
Recommended Resources:Click on the image to view the details of the training/book.
Microsoft Excel 2010 Formulas
The Ultimate Guide to
The Ultimate Guide to
Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?
| Home | Excel 2007 Tutorials | Word 2007 Tutorials | PowerPoint 2007 Tutorials | Outlook 2007 Tutorials |
| Free Templates | Free Clip Arts | Free Tips & Tricks | Free Keyboard Shortcuts | Office 2003 Books |
| Excel 2003 Tutorials | Word 2003 Tutorials | PowerPoint 2003 Tutorials | Outlook 2003 Tutorials |
| Office 2010 Tutorials | Excel 2010 Tutorials | Word 2010 Tutorials | PowerPoint 2010 Tutorials |