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