div-0-identity |
op:/ |
=1/0 |
value |
|
value-error |
op:+ |
="abc"+1 |
error-code |
|
ref-error |
INDIRECT |
=INDIRECT("ZZZ99999") |
error-code |
2 |
name-error |
feature:name-error |
=NOTAFUNCTION() |
error-code |
|
n-a-error |
VLOOKUP |
=VLOOKUP("missing", {1,2;3,4}, 2, FALSE) |
error-code |
1 |
num-error |
SQRT |
=SQRT(-1) |
error-code |
|
sum-with-one-n-a |
SUM |
=SUM(1, #N/A, 3) |
value |
|
sum-with-one-div-0 |
SUM |
=SUM(1, 1/0, 3) |
value |
|
average-with-one-error |
AVERAGE |
=AVERAGE(1, #VALUE!, 3) |
error-code |
|
count-ignores-errors |
COUNT |
=COUNT(1, #N/A, 3, #DIV/0!) |
value |
|
counta-counts-errors |
COUNTA |
=COUNTA(1, #N/A, 3, #DIV/0!) |
value |
|
max-with-error |
MAX |
=MAX(1, #N/A, 3) |
error-code |
|
min-with-error |
MIN |
=MIN(1, #VALUE!, 3) |
error-code |
|
sum-of-range-with-error-cell |
SUM |
=SUM(A1:A3) |
error-code |
|
average-of-range-with-error-cell |
AVERAGE |
=AVERAGE(A1:A3) |
error-code |
1 |
aggregate-sum-ignoring-errors |
AGGREGATE |
=AGGREGATE(9, 6, A1:A3) |
value |
2 |
iferror-catches-div-0 |
IFERROR |
=IFERROR(1/0, "err") |
value |
|
iferror-passes-clean-value |
IFERROR |
=IFERROR(42, "err") |
value |
|
iferror-catches-n-a |
IFERROR |
=IFERROR(#N/A, "fallback") |
value |
|
ifna-catches-n-a-only |
IFNA |
=IFNA(#N/A, "caught") |
value |
|
ifna-does-not-catch-div-0 |
IFNA |
=IFNA(1/0, "caught") |
value |
|
ifna-passes-clean-value |
IFNA |
=IFNA(42, "caught") |
value |
|
iferror-over-array-with-errors |
IFERROR |
=IFERROR({1, #N/A, 3}, 0) |
value |
|
iferror-over-division-with-zero |
IFERROR |
=IFERROR(10/{1,0,2}, -1) |
value |
|
error-plus-number |
op:+ |
=#N/A+1 |
error-code |
|
error-times-number |
op:* |
=#DIV/0!*5 |
error-code |
|
error-concat-string-error-handling |
op:& |
=#VALUE!&"x" |
error-code |
|
error-in-if-condition |
IF |
=IF(#N/A, "yes", "no") |
error-code |
1 |
error-in-if-true-branch-not-taken |
IF |
=IF(FALSE, #N/A, "ok") |
error-code |
1 |
error-in-if-true-branch-taken |
IF |
=IF(TRUE, #N/A, "ok") |
error-code |
1 |
iserror-on-div-0 |
ISERROR |
=ISERROR(1/0) |
value |
|
iserror-on-clean-value |
ISERROR |
=ISERROR(42) |
value |
|
iserror-on-n-a |
ISERROR |
=ISERROR(#N/A) |
value |
|
iserr-excludes-n-a |
ISERR |
=ISERR(#N/A) |
value |
|
iserr-on-div-0 |
ISERR |
=ISERR(1/0) |
value |
|
isna-on-n-a |
ISNA |
=ISNA(#N/A) |
value |
|
isna-on-div-0 |
ISNA |
=ISNA(1/0) |
value |
|
error-type-of-div-0-error-handling |
ERROR.TYPE |
=ERROR.TYPE(1/0) |
error-code |
1 |
error-type-of-n-a |
ERROR.TYPE |
=ERROR.TYPE(#N/A) |
error-code |
1 |
error-type-of-value-error-handling |
ERROR.TYPE |
=ERROR.TYPE("a"+1) |
error-code |
1 |
error-type-of-clean-value |
ERROR.TYPE |
=ERROR.TYPE(42) |
error-code |
1 |
n-a-plus-div-0-left-wins |
op:+ |
=#N/A+1/0 |
value |
|
div-0-plus-n-a-left-wins |
op:+ |
=1/0+#N/A |
value |
|
value-plus-name |
op:+ |
=("a"+1)+NOTAFUNCTION() |
value |
|
nested-error-priority |
SUM |
=SUM(#N/A, 1/0) |
error-code |
1 |