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


2 of 8

Entering the Tutorial Data
Entering the Tutorial Data

Entering the Tutorial Data

© Ted French

Entering the Tutorial Data

The first step to using the IF function in Excel is to enter the data.

Enter the data into cells D1 to F5 of an Excel worksheet as seen in the image above.

For those who do not feel like typing, the data and instructions for copying it into Excel, are available at this link.

Note: The instructions for copying the data do not include formatting steps for the worksheet.

This will not interfere with completing the tutorial. Your worksheet may look different than the example shown, but the IF function will give you the same results.

Instructions for completing the formatting for this tutorial are available in a separate tutorial entitled Format Options - Excel 2007 IF Function Tutorial.

©2014 About.com. All rights reserved.