Ctrl - Shift - Enter - Excel Array Formulas - Boolean Logic, AND & OR Criteria, Convert TRUE FALSE

Ctrl - Shift - Enter - Excel Array Formulas - Boolean Logic, AND & OR Criteria, Convert TRUE FALSE

ExcelIsFun via YouTube Direct link

min) Boolean Logic.

1 of 21

1 of 21

min) Boolean Logic.

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Ctrl - Shift - Enter - Excel Array Formulas - Boolean Logic, AND & OR Criteria, Convert TRUE FALSE

Automatically move to the next video in the Classroom when playback concludes

  1. 1 min) Boolean Logic.
  2. 2 min) AND criteria = Multiplication = All Logical Test Must Be TRUE.
  3. 3 min) SUMPRODUCT can do AND Criteria.
  4. 4 min) COUNTIFS, SUMIFS, AVERAGEIFS &
  5. 5 min) How IF function calculates AND Criteria for array calculations:
  6. 6 min) AND Can Have 2 Or More Logical Tests.
  7. 7 min) OR Criteria = Adding = At Least 1 Logical Test Must Be TRUE.
  8. 8 min) Boolean Adding for OR Criteria when result can be 2 or more.
  9. 9 min) SUMPRODUCT with Boolean Adding for OR Criteria when result can be 2 or more.
  10. 10 min) Formula goal: Count transactions that have 'Seattle' or 'Pro2'. But no 'double counting'.
  11. 11 min) Calculating notes for Array Formula: =SUMPRODUCT(--(((B76:B80=F77)+(C76:C80=F79)) Greater Than 0)).
  12. 12 min) IF function logical_test argument with Boolean Adding for OR Criteria when result can be 2 or more.
  13. 13 min) Formula goal: Find max sale for transaction that was in 'Seattle' or where 'Pro2' was sold.
  14. 14 min) Could we use DMAX to find max sale for transaction that was in 'Seattle' or where 'Pro2' was sold?
  15. 15 min) Calculation Summary for: =MAX(IF((B133:B137=F134)+(C133:C137=G134),D76:D80))
  16. 16 min) OR Criteria When There Can Never Be 2 TRUEs
  17. 17 min) Four Formulas for Counting with Mutually Exclusive OR Criteria.
  18. 18 min) MATCH function with range of values (array) in lookup_value argument.
  19. 19 min) Any math operation converts TRUEs and FALEs to 1s and 0s.
  20. 20 min) Timing Different Ways of Converting TRUEs and FALSEs to 1s and 0s.
  21. 21 min) AND and OR Criteria guidelines.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.