← The library
Excel concept
Error handling in formulas
IFERROR catches every error, IFNA only #N/A; catching too much hides real bugs.
Very commonDifficulty 1245 · Proficient
The shape of it
- In practice
Prefer IFNA around lookups and let other errors show so they get fixed.
Related
Learn the moves here — or let Wauvel run them on your numbers.
$99/mo, everything included. Free for 14 days, no card.
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.