Catching errors before they spread

Ce que vous saurez faire

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.

Étape 1 sur 6 · 1 point

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