Skip to content
Lesson 5/5

Filtering with several conditions

Exercise 1 of 3

In E2, list the amounts of North orders over 50 with one formula.

About this lesson

FILTER keeps rows that meet a condition. For several conditions, multiply them for "and" and add them for "or"; AND and OR don't work inside FILTER.

In this lesson

  1. In E2, list the amounts of North orders over 50 with one formula.
  2. In E2, list the amounts of orders that are coffee or at least 60.
  3. In E2, list the amounts of East orders over 100. There are none, so show the word "none" instead of an error.

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