Logical FunctionsIntermediate

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.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of AND, OR, NOT

0/3

The same formula in the other shapes it takes at work.

  1. AND Function

    Two conditions, and both of them have to hold.

    CoreIntermediate
  2. AND as a between test

    Inside a range means above the bottom and below the top — two conditions.

    Beginner
  3. AND over a checklist

    Ready only when every box is ticked.

    Intermediate

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.

6 rows × 4 columns5 cells you fill in
ABCD
1ApplicantYearsTest scoreShortlist
2R. Okafor578
3L. Marchetti291
4S. Beckett470
5D. Halvorsen764
6N. Achterberg385

Functions used here

What this exercise teachesMay contain 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.