9d9133 |
op:/ |
=1/0 |
value |
|
5f08cd |
op:+ |
="abc"+1 |
error-code |
|
dbea8d |
INDIRECT |
=INDIRECT("ZZZ99999") |
error-code |
2 |
f61755 |
feature:name-error |
=NOTAFUNCTION() |
error-code |
|
0e158d |
VLOOKUP |
=VLOOKUP("missing", {1,2;3,4}, 2, FALSE) |
error-code |
1 |
e7bb21 |
SQRT |
=SQRT(-1) |
error-code |
|
028836 |
SUM |
=SUM(1, #N/A, 3) |
value |
|
0f431c |
SUM |
=SUM(1, 1/0, 3) |
value |
|
8e4425 |
AVERAGE |
=AVERAGE(1, #VALUE!, 3) |
error-code |
|
e2e938 |
COUNT |
=COUNT(1, #N/A, 3, #DIV/0!) |
value |
|
801da8 |
COUNTA |
=COUNTA(1, #N/A, 3, #DIV/0!) |
value |
|
17bbd3 |
MAX |
=MAX(1, #N/A, 3) |
error-code |
|
8b21f2 |
MIN |
=MIN(1, #VALUE!, 3) |
error-code |
|
a61075 |
SUM |
=SUM(A1:A3) |
error-code |
|
86ffb0 |
AVERAGE |
=AVERAGE(A1:A3) |
error-code |
1 |
0e4d33 |
AGGREGATE |
=AGGREGATE(9, 6, A1:A3) |
value |
2 |
08bf92 |
IFERROR |
=IFERROR(1/0, "err") |
value |
|
70bd00 |
IFERROR |
=IFERROR(42, "err") |
value |
|
431376 |
IFERROR |
=IFERROR(#N/A, "fallback") |
value |
|
d747ce |
IFNA |
=IFNA(#N/A, "caught") |
value |
|
be7d93 |
IFNA |
=IFNA(1/0, "caught") |
value |
|
e6a0c5 |
IFNA |
=IFNA(42, "caught") |
value |
|
12a70f |
IFERROR |
=IFERROR({1, #N/A, 3}, 0) |
value |
|
d36f0a |
IFERROR |
=IFERROR(10/{1,0,2}, -1) |
value |
|
1d598e |
op:+ |
=#N/A+1 |
error-code |
|
9a4473 |
op:* |
=#DIV/0!*5 |
error-code |
|
b453b9 |
op:& |
=#VALUE!&"x" |
error-code |
|
f25997 |
IF |
=IF(#N/A, "yes", "no") |
error-code |
1 |
1054e8 |
IF |
=IF(FALSE, #N/A, "ok") |
error-code |
1 |
f38b4d |
IF |
=IF(TRUE, #N/A, "ok") |
error-code |
1 |
68ecd8 |
ISERROR |
=ISERROR(1/0) |
value |
|
46aff9 |
ISERROR |
=ISERROR(42) |
value |
|
177501 |
ISERROR |
=ISERROR(#N/A) |
value |
|
d1f06f |
ISERR |
=ISERR(#N/A) |
value |
|
c72e8e |
ISERR |
=ISERR(1/0) |
value |
|
160af9 |
ISNA |
=ISNA(#N/A) |
value |
|
f7c931 |
ISNA |
=ISNA(1/0) |
value |
|
8f96b3 |
ERROR.TYPE |
=ERROR.TYPE(1/0) |
error-code |
1 |
5eafca |
ERROR.TYPE |
=ERROR.TYPE(#N/A) |
error-code |
1 |
9e8ade |
ERROR.TYPE |
=ERROR.TYPE("a"+1) |
error-code |
1 |
96c8b4 |
ERROR.TYPE |
=ERROR.TYPE(42) |
error-code |
1 |
503bae |
op:+ |
=#N/A+1/0 |
value |
|
506a08 |
op:+ |
=1/0+#N/A |
value |
|
34cc1f |
op:+ |
=("a"+1)+NOTAFUNCTION() |
value |
|
bc1c25 |
SUM |
=SUM(#N/A, 1/0) |
error-code |
1 |