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

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.”

Goals

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.

Download this course

Offline version (18.1 MB)

Quick reference card

See the quick reference card for a brief, printable reminder of the key points in this course.

See more courses on Microsoft Office Training.

Applies To: Excel 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language