Logical Functions
Beginner

AND as a between test

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

Task:

A fridge passes its check when the reading is from 2 to 5 degrees inclusive. In C2:C7 return TRUE when a reading is in range and FALSE when it is not.

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.

7 rows × 3 columns6 cells you fill in
ABC
1TimeReading (°C)In range?
206:003.4
309:005
412:005.6
515:002
618:001.8
721:004.1
What this exercise teachesMay contain the answer

A chained comparison like 2<=B2<=5 looks right and is wrong: Excel compares 2<=B2 first, gets TRUE or FALSE, and then compares that to 5. AND keeps the two bounds as two separate tests, and inclusive limits mean 2.0 and 5.0 both pass.