This module will show you how to use advanced IF functions. These are very powerful functions for analyzing information. Introduction Nested IF functions IF with AND and OR COUNTIFS and SUMIFS AVERAGEIFS and IFERROR Introduction Nested IF functions IF with AND and OR COUNTIFS and SUMIFS AVERAGEIFS and IFERROR