1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel IF Function Step by Step Tutorial

By Ted French, About.com

1 of 8

The IF Function - Step by Step

The Excel IF Function

The Excel IF Function

© Ted French

How the IF function works

Note: This tutorial can be used with all versions of Excel up to and including Excel 2007. There is also a tutorial specific to Excel 2007.

The Excel IF function checks to see if a certain condition is true or false. If the condition is true, the function will do one thing, if the condition is false, the function will do something else.

The IF function we are using in this tutorial asks if the value in column A is greater than the value in column B. If it is, the IF function will place the statement "A is larger" in column D. If it is not, the IF function will place the statement "B is larger" in column D.

Our IF function will be entered into cell D1 and it looks like this:

=IF(A3 > B3,"A is larger","B is larger")

Note: the two text statements "A is larger" and "B is larger" are enclosed in quotations. In order to add text to an Excel IF Function, it must be enclosed in quotation marks.

1 of 8

Explore Spreadsheets

More from About.com

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. IF Functions
  6. Excel IF Function - How to Create an Excel IF Function - Creating an Excel IF Function

©2008 About.com, a part of The New York Times Company.

All rights reserved.