Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 3/8

AND, OR, NOT and XOR

Exercise 1 of 5

In D3, check whether Ben scored 50 or more in both tests.

About this lesson

Combine tests with AND (all must be true), OR (one is enough), NOT (the opposite) and XOR (exactly one of two).

In this lesson

  1. In D3, check whether Ben scored 50 or more in both tests.
  2. In D4, check whether Chloé scored 90 or more in at least one test.
  3. In D5, check whether Dev failed test 1 (under 50), using NOT.
  4. In D2, check whether Ana passed exactly one of the two tests (at least 50 in one, but not both).
  5. What does =AND(B2>=50, C2>=50) give for Ana (78 and 49)?

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in D3 and press Enter to check.