Must-Have Knock-Out Criteria with IF and AND
This lesson is part of the course
In this lesson
You screen seven candidates for a data analyst role at Larkfield Outdoor: three must-have rules with AND, a gated final score with IF, the best qualifying candidate and a red highlight on everyone who is out.
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
- Criteria & Weights: Making Them Add Up to 100% Locked
- Scoring Scales & Normalisation: Min-Max, Higher vs Lower Is Better Locked
- Weighted Score with SUMPRODUCT, RANK.EQ & a SORTBY Leaderboard Locked
- Must-Have Knock-Out Criteria with IF and AND Locked
- Pairwise Comparison Weights (AHP-Style Row Averages) Locked
- Sensitivity: How Far Must a Weight Move to Flip the Winner? Locked
- Multiple Evaluators: Averages, Spread & Disagreement Flags Locked
- Final Decision Dashboard: Score, Rank, Budget Cut-Off & Sorted Bar Chart Locked