Count how many conditions are met
TRUE counts as 1 in arithmetic, so conditions can be added up.
Task:
A supplier scorecard checks three things: on-time rate of at least 95%, defect rate under 2%, and a valid certificate. In E2:E6 give each supplier's score out of 3 — the number of checks they pass.
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of Complex Logical Combinations
0/4The same formula in the other shapes it takes at work.
- Complex Logical Combinations
Combine multiple logical functions for complex conditions.
CoreAdvanced - OR of two ANDs: two routes to yes
Approved either on the numbers, or on a guarantor — two complete rules joined.
Advanced - Count how many conditions are met
TRUE counts as 1 in arithmetic, so conditions can be added up.
Advanced - At least two of three
A majority rule that AND and OR cannot express on their own.
Advanced
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Supplier | On time | Defects | Certified | Score |
| 2 | Kestrel | 0.97 | 0.01 | Yes | |
| 3 | Lumen | 0.93 | 0.015 | Yes | |
| 4 | Morrow | 0.99 | 0.025 | No | |
| 5 | Nimbus | 0.91 | 0.04 | No | |
| 6 | Orbit | 0.95 | 0.02 | Yes |
What this exercise teachesMay contain the answer
AND only says whether all three passed; adding the conditions says how many did, which is far more useful for ranking suppliers. Orbit hits 95% exactly (a pass) but has a defect rate of exactly 2% (a fail, since the rule is under 2%).