Excel concept

Error values

Each error tells you what went wrong: #N/A not found, #REF! deleted reference, #NAME? unknown name, #VALUE! wrong type, #DIV/0! divided by zero, #NUM! bad number, #SPILL! blocked array, ##### too narrow.

Daily driverDifficulty 1109 · Proficient

Practice · 21 questions →

The shape of it

In practice: Read the error before wrapping anything in IFERROR. Trace Precedents and Evaluate Formula show where it started.

Relative, absolute, and mixed references Numbers stored as text How dates and times work Excel Tables Choosing a lookup function Pivot tables

Learn the moves here — or let Wauvel run them on your numbers.

$99/mo, everything included. Free for 14 days, no card.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.

Error values

The shape of it

Related