Page 1 of 5PREVNEXT

The IF function: what it is, and how to use it

Judi Hurlock

The IF function checks to see if a condition you specify is true or false. If true, one thing happens; if false, something else happens. For example, if you use the IF function to see if amounts spent are under or over budget, the result for True could be “Within budget,” while the result for False could be “Over budget.”
By Judi Hurlock, Senior Writer.

Applies to:

Offline version (18.1 MB)

About this course

This course includes:

  • One self-paced lesson.
  • One practice session for hands-on experience. The practice requires Excel 2010.
  • A short test at the end of the lesson. The test is not scored.
  • A Quick Reference Card you can print at the end of the course.


After completing this course you will be able to:

  • Use the IF function
  • Use more than one IF function in a formula

Before you begin

You should already be familiar with Excel formulas. If you are new to formulas, try this course first: Get to know Excel 2010: Create formulas.

See more courses on Microsoft Office Training.

Page 1 of 5PREVNEXT