Skip to content

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

Lesson 4/8

IF with AND and OR

Exercise 1 of 3

Students who score 50 or more in both tests pass, the others must retake. In D2, show "Pass" or "Retake" for Ana.

About this lesson

Put AND or OR inside IF to make decisions that depend on more than one test.

In this lesson

  1. Students who score 50 or more in both tests pass, the others must retake. In D2, show "Pass" or "Retake" for Ana.
  2. Students with 90 or more in either test get an award. In D4, show "Award" for Chloé, or leave it empty otherwise.
  3. Shipping is free for orders of 50 or more, or for members. Everyone else pays 4.99. In D2, work out the shipping for order 2001.

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 D2 and press Enter to check.