Skip to content

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

Lesson 1/8

TRUE and FALSE

Exercise 1 of 3

In C3, check whether Ben passed: is his score at least 50? The answer is TRUE or FALSE.

About this lesson

A comparison such as =B2>=50 answers a yes-or-no question with TRUE or FALSE. Those answers are what IF, AND, OR and conditional formatting work with.

In this lesson

  1. In C3, check whether Ben passed: is his score at least 50? The answer is TRUE or FALSE.
  2. In D3, check whether Ben did better in test 2 than in test 1.
  3. A score of exactly 50 is in B2. What does =B2>=50 return?

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