ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
IFERROR Function — The Protective Clause
3
sheetsandcells.com/functions/iferror/ · Catch every error, replace it with a fallback
4
5
✓ Universal support since Excel 2007
6
IFERROR ships in Excel 2007, 2010, 2013, 2016, 2019, 2021, 365, Excel for the web, Google Sheets, LibreOffice, Apple Numbers. Catches ALL 7 Excel error types: DIV/0, VALUE, REF, NAME, N/A, NULL, NUM. For older Excel (2003 and earlier), use the IF+ISERROR combo shown in Sheet 7.
7
8
Sheet Map — What's Inside
9
10
2. Sales LogSame 24-row Q1 2026 sales data used across the function library.
11
3. Example 1 - DIV/0 WrapBasic pattern — commission on quota, some quotas are 0.
12
4. Example 2 - VLOOKUP Fallback
Turn N/A error into a readable message when lookup fails.
13
5. Example 3 - Cascade ChainNested IFERROR — try lookup #1, then #2, then text default.
14
6. Example 4 - IFERROR vs IFNA
IFNA only catches N/A. IFERROR catches everything. Which to choose.
15
7. Example 5 - Legacy IF+ISERROR
The Excel 2003-compatible pattern before IFERROR existed.
16
8. 7 Error Types MatrixWhat each error means and which functions catch each one.
17
9. Cheat Sheet10 IFERROR patterns you'll use every day.
18
19
20
⚠ The bug swallower problem
21
IFERROR hides ALL errors — including bugs you'd want to know about. If your formula gets a REF error because you deleted a row, IFERROR silently returns your fallback instead of flagging the bug. Use IFERROR for EXPECTED errors (missing lookup, zero denominator, optional cell). Never as a catch-all bug swallower. When in doubt, wrap the specific inner formula, not the whole expression.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100