Logical Functions
Intermediate

AND over a checklist

Ready only when every box is ticked.

Task:

A new starter can be given a desk once IT, HR and Facilities have each signed off. In E2:E6 show Ready when all three columns say Yes, otherwise Waiting.

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.

    Core
    Intermediate
  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 × 5 columns5 cells you fill in
ABCDE
1StarterITHRFacilitiesStatus
2N. OkaforYesYesYes
3P. SilvaYesNoYes
4Q. LarsenNoNoNo
5R. HaddadYesYesNo
6S. MoreauYesYesYes
What this exercise teachesMay contain the answer

One No anywhere is enough to keep someone waiting, which is exactly how AND behaves: it is TRUE only if nothing inside it is FALSE. Adding a fourth sign-off later means adding one more condition, not another layer of IF.