This module will show you how to use advanced IF functions. These are very powerful functions for analyzing information.

  1. Introduction
  2. Nested IF functions
  3. IF with AND and OR
  4. COUNTIFS and SUMIFS
  5. AVERAGEIFS and IFERROR

Introduction

Nested IF functions

IF with AND and OR

COUNTIFS and SUMIFS

AVERAGEIFS and IFERROR