Skip to content

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

Lesson 8/8

IFERROR: catch errors

Exercise 1 of 3

The notebooks have 0 units, so dividing gives an error. In D3, work out the cost per unit, but show 0 instead of an error.

About this lesson

IFERROR shows a value of your choice instead of an error, such as a division by zero.

In this lesson

  1. The notebooks have 0 units, so dividing gives an error. In D3, work out the cost per unit, but show 0 instead of an error.
  2. Do it again in D3, but show "no units" instead of an error.
  3. When does IFERROR use its second argument?

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.