Introduction to Logical Functions (FULL COURSE)

An introduction to the most commonly used logical functions.

The topics:

  • How to construct a basic IF function
  • Understanding relational operators
  • Using SUMIF and COUNTIF functions
  • Boolean logic with AND and OR functions
  • Using IFERROR to eliminate #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!