At least two of three
A majority rule that AND and OR cannot express on their own.
Task:
A candidate goes through to final interview when at least two of the three interviewers voted Yes. In E2:E6 show Through or Not through.
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 | Candidate | Panel 1 | Panel 2 | Panel 3 | Result |
| 2 | C-11 | Yes | Yes | No | |
| 3 | C-12 | No | Yes | No | |
| 4 | C-13 | Yes | Yes | Yes | |
| 5 | C-14 | No | No | No | |
| 6 | C-15 | Yes | No | Yes |
What this exercise teachesMay contain the answer
Two of three can be written as OR of three ANDs — (1 and 2) or (1 and 3) or (2 and 3) — but that grows badly with every extra panel member. Counting votes and comparing with a threshold stays one line however big the panel gets. COUNTIF(B2:D2,"Yes")>=2 is the same idea when the cells sit side by side.