Skip to content

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

Lesson 1/4

#DIV/0!: dividing by zero

Exercise 1 of 3

Column D divides sales by orders. Why does D3 show #DIV/0!?

About this lesson

#DIV/0! means a formula divided by 0 or by an empty cell. Fix the data, or catch the case with IF or IFERROR when a zero is expected.

In this lesson

  1. Column D divides sales by orders. Why does D3 show #DIV/0!?
  2. D3 shows #DIV/0! because South had no orders. Change its formula so it shows 0 when there are no orders, and the sales per order otherwise.
  3. E2 averages the West orders, but there are none, so it shows #DIV/0!. Keep the formula and make it show 0 instead.

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

Try it out: type a formula in any free cell or change a value. What you type on the sheet isn’t graded.