Logical Functions in Excel

Microsoft Excel allows you to perform many amazing calculations by combining logical functions with operation functions. For example, “count how many projects were completed ahead of time,” can be restated as “if a project was completed ahead of time, then count it.” Once you understand the lingo, the world of Excel logical functions opens up to you.

  1. Logical Functions and the True/False Paradigm
  2. SumIf()
  3. AverageIf(), AverageIfs(), CountIf() and CountIfs()
  4. IF() vs. IFS()
  5. CountBlank()
  6. And() vs. Or()
  7. Building Compound Logical Functions
  8. IfError()
  9. Not()
  10. Switch()