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.

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

 

Hector Garcia

Hector Garcia

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

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.



Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

Share on linkedin
Share on facebook
Share on twitter
Share on whatsapp
Share on email
Share on print

30% Off QuickBooks

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