Intermediate
Logical
IFERROR
Returns a fallback value if a formula results in an error, otherwise returns the formula's normal result.
Compatibility: All Excel versions
Syntax
=IFERROR(value, value_if_error)
Example
=IFERROR(A1/B1,"N/A")
When to Use It
Use IFERROR to wrap a formula that might fail (like a lookup that might not find a match, or a division that might divide by zero) so it shows something readable instead of an error code.