Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Lesson 7

Excel errors and IFERROR

Recognise the common error values and catch them with IFERROR, so your sheet stays clean.

  1. What does it mean?.
  2. Hide #DIV/0!. The new store has no orders yet, so B2/C2 divides by zero and gives #DIV/0!. IFERROR shows your own value instead. Divide revenue by orders in D2, and show 0 instead of #DIV/0!
  3. Which error?.
  4. Your turn: IFERROR. IFERROR shows your own text when a formula gives an error. Kiwi isn't in the list, so VLOOKUP alone would show #N/A. Look up the stock of Kiwi in F2 and show "Not found" instead of an error

← All lessons