What is IFERROR?
Catches errors in formulas and returns an alternative value. Essential for creating robust spreadsheets that handle edge cases gracefully.
Syntax
=IFERROR(value, value_if_error)
Example
Formula: =IFERROR(A1/B1, \
Result: 5 or \
How It Works
If A1/B1 produces an error (like division by zero), returns 'Error'. Otherwise returns the calculation result. Catches all error types: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!.