Home › Learn Excel › Lesson 7
Recognise the common error values and catch them with IFERROR, so your sheet stays clean.
#DIV/0!. IFERROR shows your own value instead. Divide revenue by orders in D2, and show 0 instead of #DIV/0!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