How to use advanced IF formulas in Excel

Description: Follow the link below 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.

Link: https://support.office.com/en-us/article/Advanced-IF-functions-17341cef-510d-4d60-a657-913f878fdacf?ui=en-US&rs=en-US&ad=US