Modern Excel Formulas

Boolean logic

Modern Excel Formulas Lessons Boolean logic

Summary

This video looks at how Boolean logic can be applied within Excel.

The term boolean logic means it uses true/false values with the calculation.

TRUE or FALSE are automatically converted to 1 or 0 when used in an arithmetic calculation.

Combining TRUE/FALSE and multiplication in a calculation simulates IF logic for numerical values.

Any non-zero number is deemed to be TRUE and zero is deemed to be FALSE. However, numbers are not equal to TRUE or FALSE.

Multiplication create And logic.

Addition creates Or logic.

Lessons

  1. Welcome & introduction
  2. Download the example files
  3. From ranges to arrays
  4. Arrays & array functions
  5. Lifting
  6. Example (Part #1)
  7. Broadcasting
  8. Example (Part #2)
  9. Pairwise lifting
  10. Example (Part #3)
  11. Boolean logic
  12. Example (Part #4)
  13. Variables (LET Function)
  14. Example (Part #5)
  15. Lookup example
  16. Wrap up
  17. Feedback