⚠️ Error Catchers

Goal: Detect errors to show cleaner messages.
ISNA: Catches only #N/A.
ISERROR: Catches EVERYTHING (#N/A, #DIV/0!, #VALUE!, etc).

ISNA: -
ISERROR: -
ISNA()
ISERROR()
100
Ready...

💻 Formula Structure

=ISERROR(value)
  • Scope: Catches ALL errors.
  • Use Case: "If anything goes wrong, show 0."
=ISNA(value)
  • Scope: Catches ONLY #N/A.
  • Use Case: "If VLOOKUP fails, say 'Not Found', but let me know if I have a math error."
-- Check A1 for errors
=ISERROR( A1 )
Trap Result:
-

⚠️ Best Practices

💡 Modern Alternative
Instead of =IF(ISERROR(A1), 0, A1), use the cleaner IFERROR(A1, 0) function. It combines the logic into one step.
✅ Why use ISNA?
Sometimes you want to see #DIV/0! errors to fix your math, but you want to hide #N/A lookups. IFNA or ISNA is safer than IFERROR in these cases.