The IF function is one of Excel’s most useful and most used functions. The IF function introduces decision making into a spreadsheet. Depending on whether or not specified criteria are met, the IF function will produce different results. These tutorials cover creating and using the IF function in Excel.
Excel 2007 IF Function Step by Step Tutorial
Excel 2007 IF Function Tutorial
This tutorial uses the IF function to calculate a fictitious annual deduction for employees based on their yearly salary.
The function tests to see if an employee's salary is above or below the threshold of $30,000. Depending on the result, different deduction rates are used in calculating the annual deduction for a number of employees.
Excel 2007 Nested IF Function Step by Step Tutorial
Excel 2007 IF Function Tutorial
The usefulness of the IF function can be extended by using one or more Nested IF functions. A nested function in Excel refers to one function being placed inside another.
Nested IF functions increase the number of possible outcomes that can be tested for and increase the number of actions that can be taken to deal with these outcomes.
This step by step tutorial extends the above IF function tutorial by introducing multiple deduction levels based on employee salaries.
Excel 2007 IF Function - text version
Excel 2007 IF Function Tutorial
This IF function tutorial is intended for those who have experience working with Excel functions. A simple example of how the IF function works is covered using text - only instructions.
IF Function Format Tutorial Part 1
Excel 2007 IF Function Format Tutorial
This two part tutorial covers the steps used to format the worksheet completed in the Excel 2007 IF Function Step by Step Tutorial.
Although this tutorial makes use of a worksheet from a previous tutorial, it is not necessary to complete the IF function tutorial first. The format options covered in this tutorial can be applied to any Excel 2007 worksheet.
IF Function Format Tutorial Part 2
Excel 2007 IF Function Format Tutorial
This tutorial is a continuation of a tutorial that covers the steps used to format the Excel 2007 IF Function Step by Step Tutorial.
Although this tutorial makes use of a worksheet from a previous tutorial, it is not necessary to complete the IF function tutorial first. The format options covered in this tutorial can be applied to any Excel 2007 worksheet.
