Close this search box.

Advanced IF function in Excel

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.


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


Hector Garcia

Hector Garcia

Use our link to get 30% off for a year, valid through 07/31/2022

Leave a Reply

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

Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course


30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022