Syntax
=IFERROR(value, value_if_error)- value: Formula or expression to evaluate.
- value_if_error: Result to return if an error occurs.
Practical Examples
Example 1: Division
=IFERROR(A2/B2, "Cannot divide")| A | B | Result |
|---|---|---|
| 10 | 2 | 5 |
| 10 | 0 | Cannot divide |
Example 2: VLOOKUP
=IFERROR(VLOOKUP("Apple", A2:B10, 2, FALSE), "Not Found")Example 3: Text Formula
=IFERROR(LEFT(A2,5), "Error")Nested IFERROR
=IFERROR(A2/B2, IFERROR(C2/D2, "Error"))Tries multiple calculations sequentially and handles any error gracefully.
Tips & Notes
- IFERROR handles all Excel errors like
#DIV/0!,#N/A,#VALUE!. - Use
""to display blank instead of an error message. - Do not overuse IFERROR to hide real data issues.
Common Errors
- Using IFERROR with blank formulas might hide unintended mistakes.
- IFERROR only evaluates the first argument, ensure correct order in nested IFERROR.
FAQs
Can IFERROR handle text errors?
Yes, any Excel error returned by a formula is caught by IFERROR.
Difference between IFERROR and IFNA?
IFERROR handles all errors, IFNA only handles #N/A errors.
Download Template
Practice IFERROR with ready Excel template.