AND only turns TRUE when every argument inside it does, and one of those arguments here is itself an OR — so a request can satisfy either of two routes and still has to clear the tenure rule on top.
You run tuition reimbursement requests for HR at a mid-size firm. The policy: an employee qualifies if they have been employed at least 12 months, and the course is either job-related or was pre-approved by their manager — tenure is never waived, but either of the other two is enough on its own. In E2, work out each request in column E as "Eligible" or "Not eligible", then copy down to row 6.
Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.
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 | Employee | Months employed | Job-related | Manager pre-approved | Eligible |
| 2 | Alders | 18 | Yes | No | |
| 3 | Brandt | 6 | Yes | Yes | |
| 4 | Corwin | 24 | No | No | |
| 5 | Delgado | 15 | No | Yes | |
| 6 | Ekstrom | 9 | No | Yes |
AND only returns TRUE when both of its arguments do, and its second argument here is OR(C2="Yes",D2="Yes") — which is itself TRUE the moment either half is. That is why Brandt, six months in with both the job-related and pre-approved boxes checked, still comes back Not eligible: the OR clears easily, but AND's other argument, the tenure check, does not, and AND cannot pass on one true argument alone. Delgado is the mirror case — a course that is neither job-related nor pre-approved by itself, but fifteen months of tenure plus manager approval is enough to clear the OR, and with tenure already satisfied that is all AND needs. Flattening this into a single OR of three conditions would have reimbursed Brandt's course on day one, which is exactly what the tenure rule exists to prevent.