Catching errors before they spread

Lo que podrás hacer

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.

Paso 1 de 6 · 1 punto

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