1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel IF Function Step by Step Tutorial


1 of 8

How the IF Function Works
The Excel IF Function

The Excel IF Function

© Ted French

IF Function Overview

Related Tutorial: Text only version - Excel IF Function Quick Tutorial

The Excel IF function adds flexibility to your spreadsheets by introducing decision making. It does this by testing a specified condition in your spreadsheet to see if it is true or false.

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.

Tutorial Topics

©2014 About.com. All rights reserved.