First, you can download the Full Course here from the Microsoft website, or watch the videos online:

1 – Advanced IF Function

Before we get started with advanced IF functions, let’s do a quick IF function refresher first. Watch this video for some examples.

 

 

 

2 – Nested IF Function

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

 

 

3 – IF Function with AND & OR Nested

Watch this video to see how to extend the functionality of the IF function by nesting AND and OR functions.

4 – Working with COUNTIFS and SIMIFS

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 – IFERROR and AVERAGEIFS

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

Source: From Microsoft’s Online Course Page

 

Share →

Leave a Reply

Your email address will not be published. Required fields are marked *



For More Information

Call us to 954-633-2718 or email: hector@quickbooks-training.net