IF Function Overview
Related Tutorial: Text only version - Excel IF Function Quick Tutorial
If the condition is true, the function will carry out one action. If the condition is false, it will carry out a different action.
The function allows you to specify what actions it should carry out depending on whether the condition is true or not. These actions can include executing a formula, inserting a text statement, or leaving the target cell blank.
IF Function Step by Step 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.
Following the steps in the tutorial topics below walks you through creating and using the IF function seen in the image above to calculate this deduction for multiple employees.
Instructions for completing the formatting for this tutorial are available in a separate tutorial entitled Excel Format Tutorial Part 1.