Catching errors before they spread

What you will be able to do

Read Excel's error values, trap the ones you expect without hiding the ones you do not, and trace a wrong number back to its cause.

A formula that errors is annoying. A formula that returns a plausible wrong number is expensive. This lesson is about telling the two apart, and about not converting the first into the second.

Step 1 of 6 · 1 point

A lookup returns #N/A. What is Excel telling you?