Video: Nested IF functions

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

Other videos in this course

This video is part of a training course called Advanced IF functions. You can download the entire course or watch the videos online:

  1. Video: Advanced IF functions. Before we get started with advanced IF functions, let's do a quick IF function refresher first. Watch this video for some examples.
  2. Video: Nested IF functions. (You are here!) Nested IF functions, meaning one IF function inside of another, allow you to test multiple criteria and increases the number of possible outcomes.
  3. Video: IF with AND and OR. Watch this video to see how to extend the functionality of the IF function by nesting AND and OR functions.
  4. Video: COUNTIFS and SUMIFS. 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.
  5. Video: AVERAGEIFS and IFERROR. AVERAGEIFS returns the average of all cells that meet multiple criteria. IFERROR returns the value specified if AVERAGEIFS evaluates to an error.

Need a reminder of what you learned? See the course summary.

Ready for another tutorial? See the complete list of Excel 2013 training courses.

Rating:
Applies to:
Views:
40736
Submitted on:
2/2/2013
Length:
00:03:31