27b6f8 |
IF |
=IF(TRUE, 1, 2) |
value |
1 |
f59750 |
IF |
=IF(FALSE, 1, 2) |
value |
1 |
b9debc |
IF |
=IF(2>3, TRUE, FALSE) |
value |
1 |
256871 |
IF |
=IF(2>3, TRUE) |
value |
|
4c724d |
IF |
=IF(1>2, "a", IF(3>2, "b", "c")) |
value |
|
48318a |
AND |
=AND(TRUE, TRUE, TRUE) |
value |
1 |
646f43 |
AND |
=AND(TRUE, FALSE, TRUE) |
value |
1 |
d87b4e |
AND |
=AND(1, 1, 0) |
value |
|
2b94c4 |
AND |
=AND() |
value |
|
b50b2c |
OR |
=OR(FALSE, TRUE, FALSE) |
value |
1 |
c0f2e8 |
OR |
=OR(FALSE, FALSE, FALSE) |
value |
1 |
40d4ad |
OR |
=OR(0, 0, 1) |
value |
|
a8974a |
NOT |
=NOT(TRUE) |
value |
1 |
686333 |
NOT |
=NOT(FALSE) |
value |
1 |
1e40de |
XOR |
=XOR(TRUE, TRUE, TRUE) |
value |
2 |
06fb8b |
XOR |
=XOR(TRUE, TRUE) |
value |
2 |
608087 |
XOR |
=XOR(FALSE, FALSE) |
value |
2 |
eaa848 |
IFERROR |
=IFERROR(1, "error") |
error-code |
|
86ae0a |
IFERROR |
=IFERROR(1/0, "error") |
error-code |
|
126db9 |
IFERROR |
=IFERROR(IFERROR(1/0, 1/0), "both failed") |
value |
|
3c7a91 |
IFNA |
=IFNA(1, "na") |
error-code |
1 |
227e4f |
IFNA |
=IFNA(MATCH(99, {1,2,3}, 0), "not found") |
value |
1 |
84569a |
SWITCH |
=SWITCH(1, 1, "one", 2, "two") |
value |
1 |
ef86ac |
SWITCH |
=SWITCH(2, 1, "one", 2, "two") |
value |
1 |
0b3ad8 |
SWITCH |
=SWITCH(99, 1, "one", 2, "two", "other") |
value |
1 |
e5fe7a |
SWITCH |
=SWITCH(99, 1, "one", 2, "two") |
value |
1 |
da13f1 |
IFS |
=IFS(TRUE, "a", TRUE, "b") |
value |
1 |
833378 |
IFS |
=IFS(FALSE, "a", TRUE, "b") |
value |
1 |
5de080 |
IFS |
=IFS(FALSE, "a", FALSE, "b") |
value |
1 |
2328d5 |
CHOOSE |
=CHOOSE(1, "a", "b", "c") |
value |
|
8cad26 |
CHOOSE |
=CHOOSE(3, "a", "b", "c") |
value |
|
44d3f1 |
CHOOSE |
=CHOOSE(5, "a", "b", "c") |
value |
|