Advanced IF functions

Advanced IF functions

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.

Applies to:
File Size:

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.