Logical Functions
Intermediate
AND Function
Two conditions, and both of them have to hold.
Task:
You are shortlisting for an interview and the bar is at least 3 years of experience and a test score of 70 or better. Both have to be true — a brilliant test result does not buy someone the experience. Mark each applicant in column D.
Learning Objectives:
- Combine two conditions with AND
- Wrap AND in IF to return text
- Get the boundary right with >=
Hints
Solve without hints for +5 XP
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 | |
|---|---|---|---|---|
| 1 | Applicant | Years | Test score | Shortlist |
| 2 | R. Okafor | 5 | 78 | |
| 3 | L. Marchetti | 2 | 91 | |
| 4 | S. Beckett | 4 | 70 | |
| 5 | D. Halvorsen | 7 | 64 | |
| 6 | N. Achterberg | 3 | 85 |
What this exercise teaches (contains the answer)
Two applicants sit exactly on a boundary: one has exactly 3 years, one scored exactly 70. Both make the list, because the rule says "or better". That is the whole difference between >= and >, and it is the most common way a shortlist quietly drops someone who qualified.