Video:Overview of IF Functions in Excelwith Nick Flegg
Improving your Excel skills will save you time if you're managing large amounts of data. Take your spreadsheets further with the overview of the IF function in this how-to video from About.com.See Transcript
Transcript:Overview of IF Functions in Excel
Hi, I'm Nick and today for About.com, I'm going to give you an overview of the IF function in Excel 2010.
What is the IF Function in Excel?
The IF function allows you to compare multiple cells and give a total based on pre-determined conditions.
Get started with the IF function by clicking on the Formulas ribbon and selecting the Logical menu. From here, choose IF to open the IF window. This will help assemble the correct formula.
Using the IF Function in Excel
In the Logical_Test box, enter the reference of the cell you wish to be evaluated. In this example, we're going to be checking the total of 50, located in cell B5. Before you move on, you need to enter the value that this should be compared to. Here, any figure under 100 will be considered 'true', so the formula <100 is entered.
In the Value_if_true box, enter the condition that will be applied if the selected cell's total is less than 100. In this example, a 5% charge will be added, located in the cell B2. Make this formula absolute by pressing F4 and then adding an asterisk to multiply with cell B5.
The Value_if_false box follows the same method, instead requiring the cell reference for items greater than 100. In this case, the value will be set at 10%, so select cell B3, press F4 to make the reference absolute and then multiply by cell B5.
Click OK and the total will automatically appear, from the data you've entered. In this case, 5% of 50 is 2.5. If you want to apply this formula to multiple cells, you can simply click the bottom right corner of the active cell and drag over the cells you wish the formula to apply to.
Now you know how to use the IF function in Excel. For more tips and tricks, be sure to visit compute.about.com.