IFERROR
Logical FormulasLearn IFERROR to catch and handle formula errors gracefully. Replace #N/A, #VALUE!, #DIV/0! and other errors with custom values.
Syntax
IFERROR(value, value_if_error)Parameters
valueThe formula or value to check for errors
value_if_errorThe value to return if an error is found
Examples
=IFERROR(VLOOKUP(A1,B:C,2,0), "Not Found")Return 'Not Found' if VLOOKUP fails
=IFERROR(A1/B1, 0)Return 0 instead of #DIV/0!
=IFERROR(VALUE(A1), A1)Try to convert to number, keep original if fails
Common Errors
Catches ALL errors - may hide unexpected issues
Pro Tips
Use IFNA for #N/A errors only
Don't overuse - errors can indicate real problems
Consider ISERROR for conditional logic
Related Functions
Need Help with IFERROR?
Describe your specific use case and our AI will generate the perfect IFERROR formula for you.
Generate IFERROR Formula