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

Enter the Data for the IF Function
Data for the IF Function Example

Data for the IF Function Example

© Ted French

Enter the data for the IF function

It is always a good idea to enter all your data into a spreadsheet before you begin writing functions or formulas. This way you will know if there are any layout problems and it is less likely that you will need to make corrections to your functions later.

To begin this tutorial, add the following data to a worksheet so it resembles the example above:

    Cell Data
    A3 -- 23
    A4 -- 30
    A5 -- 45
    A6 -- 57
    B3 -- 20
    B4 -- 45
    B5 -- 40
    B6 -- 60

©2014 About.com. All rights reserved.