By Ted French

**How the IF function works**

**Related Tutorial:** Excel 2007 / 2010 IF Function Step by Step Tutorial

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.

Previous

- The IF Function - Step by Step Tutorial
- Enter the Data for the IF Function
- Starting the IF Function
- Parts of the IF Function
- Writing the IF Function Logic Test
- Adding the "Value if True" Argument to the IF Function
- Adding the "Value if False" Argument to the IF Function
- Copying the IF Function to Other Cells

Explore Spreadsheets

Must Reads

- Basic Formulas and Functions Tutorial
- Beginners Guide to Excel
- Excel Step by Step Format Tutorial
- Excel Formulas: Free Email Course
- Excel Data Management: Free Email Course

Most Popular

See More About:

By Category

- Excel 101- How to Use Excel
- Formulas in Excel
- Excel Functions
- Excel VLOOKUP Tutorials
- Data Management in Excel
- Excel Shortcut Keys
- Formatting Options in Excel
- Excel How To Videos
- Charts and Graphs
- Excel Tips, Tools and Templates
- Advanced Excel
- Excel 2003 Tutorials
- Google Spreadsheets
- Other Excel Alternative Spreadsheet Tutorials
- Excel Glossary of Terms

- About.com
- Computing
- Spreadsheets
- Excel Functions
- IF Functions
- Excel IF Function Step by Step Tutorial