Catching errors before they spread

Was du danach kannst

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.

Schritt 1 von 6 · 1 Punkt

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