Case 3: IF, IFS, AND and OR Logic
This lesson is part of the course
In this lesson
Suggested time: 10 minutes. You decide for eight reps who hit target, who gets a bonus, which commission tier applies and who is on a commission hold.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Case 1: Lookups with XLOOKUP, INDEX/MATCH and Tier Tables Locked
- Case 2: SUMIFS and COUNTIFS Report Locked
- Case 3: IF, IFS, AND and OR Logic Locked
- Case 4: Percentages, Growth and the Classic Traps Locked
- Case 5: Text Cleanup and Concatenation Locked
- Case 6: Date Calculations with EOMONTH, NETWORKDAYS and DATEDIF Locked
- Case 7: Pivot-Style Summary with Formulas Locked
- Case 8: Final Mixed Assessment Locked