if-true-branch |
IF |
=IF(TRUE, 1, 2) |
value |
1 |
if-false-branch |
IF |
=IF(FALSE, 1, 2) |
value |
1 |
if-with-comparison |
IF |
=IF(2>3, TRUE, FALSE) |
value |
1 |
if-two-args-false |
IF |
=IF(2>3, TRUE) |
value |
|
if-nested |
IF |
=IF(1>2, "a", IF(3>2, "b", "c")) |
value |
|
and-all-true |
AND |
=AND(TRUE, TRUE, TRUE) |
value |
1 |
and-one-false |
AND |
=AND(TRUE, FALSE, TRUE) |
value |
1 |
and-with-numbers |
AND |
=AND(1, 1, 0) |
value |
|
and-empty |
AND |
=AND() |
value |
|
or-one-true |
OR |
=OR(FALSE, TRUE, FALSE) |
value |
1 |
or-all-false |
OR |
=OR(FALSE, FALSE, FALSE) |
value |
1 |
or-with-numbers |
OR |
=OR(0, 0, 1) |
value |
|
not-true |
NOT |
=NOT(TRUE) |
value |
1 |
not-false |
NOT |
=NOT(FALSE) |
value |
1 |
xor-odd-trues |
XOR |
=XOR(TRUE, TRUE, TRUE) |
value |
2 |
xor-even-trues |
XOR |
=XOR(TRUE, TRUE) |
value |
2 |
xor-all-false |
XOR |
=XOR(FALSE, FALSE) |
value |
2 |
iferror-no-error |
IFERROR |
=IFERROR(1, "error") |
error-code |
|
iferror-with-error |
IFERROR |
=IFERROR(1/0, "error") |
error-code |
|
iferror-nested |
IFERROR |
=IFERROR(IFERROR(1/0, 1/0), "both failed") |
value |
|
ifna-no-error |
IFNA |
=IFNA(1, "na") |
error-code |
1 |
ifna-with-na |
IFNA |
=IFNA(MATCH(99, {1,2,3}, 0), "not found") |
value |
1 |
switch-match-first |
SWITCH |
=SWITCH(1, 1, "one", 2, "two") |
value |
1 |
switch-match-second |
SWITCH |
=SWITCH(2, 1, "one", 2, "two") |
value |
1 |
switch-with-default |
SWITCH |
=SWITCH(99, 1, "one", 2, "two", "other") |
value |
1 |
switch-no-match-no-default |
SWITCH |
=SWITCH(99, 1, "one", 2, "two") |
value |
1 |
ifs-first-match |
IFS |
=IFS(TRUE, "a", TRUE, "b") |
value |
1 |
ifs-second-match |
IFS |
=IFS(FALSE, "a", TRUE, "b") |
value |
1 |
ifs-no-match |
IFS |
=IFS(FALSE, "a", FALSE, "b") |
value |
1 |
choose-first |
CHOOSE |
=CHOOSE(1, "a", "b", "c") |
value |
|
choose-third |
CHOOSE |
=CHOOSE(3, "a", "b", "c") |
value |
|
choose-out-of-range |
CHOOSE |
=CHOOSE(5, "a", "b", "c") |
value |
|