Advanced IF functions

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

Take this course to learn complex examples and variations of the IF function in Excel, including nested IF functions, IF with AND and OR, COUNTIFS and SUMIFS, and AVERAGEIFS and IFERROR.

Inside this course:

Advanced IF functions (3:23)
Before we get started with advanced IF functions, let's do a quick IF function refresher first. Watch this video for some examples.

Nested IF functions (3:31)
Nested IF functions, meaning one IF function inside of another, allow you to test multiple criteria and increases the number of possible outcomes.

IF with AND and OR (3:35)
Watch this video to see how to extend the functionality of the IF function by nesting AND and OR functions.

COUNTIFS applies criteria to cells across multiple ranges and counts the number of times all criteria are met. SUMIFS adds the cells in a range that meet multiple criteria.

AVERAGEIFS returns the average of all cells that meet multiple criteria. IFERROR returns the value specified if AVERAGEIFS evaluates to an error.

Course summary
A brief reminder of the key points in this course.

More courses available at Microsoft Office Training.

Applies To: Excel 2013

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!

Change language