Skip to content
Lesson 7/8

ISNUMBER, ISTEXT, ISBLANK, ISERROR

Exercise 1 of 5

In C2, check whether Ana's score is a number.

About this lesson

ISNUMBER, ISTEXT, ISBLANK and ISERROR tell you what a cell holds, or whether a calculation fails, so you can catch wrong or missing data.

In this lesson

  1. In C2, check whether Ana's score is a number.
  2. In C3, check whether Ben's entry is text.
  3. In C5, check whether Dev's score cell is empty.
  4. In C3, show Ben's score if it's a number, otherwise 0.
  5. Notebooks have 0 units, so dividing their cost by their units fails. In D3, check whether B3/C3 gives 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 C2 and press Enter to check.