logical functions
branch and combine conditions.
| function | signature | what it does | tests |
|---|---|---|---|
| AND | AND(logical…) | returns TRUE if all arguments are true | 27 |
| FALSE | FALSE() | returns the logical value FALSE | 13 |
| IF | IF(condition, value_if_true, [value_if_false]) | returns one value if condition is true, another if false | 3 |
| IFERROR | IFERROR(value, value_if_error) | returns value if no error, otherwise alternate | 1 |
| IFNA | IFNA(value, value_if_na) | returns value if not #N/A, otherwise alternate | — |
| IFS | IFS(logical_test1, value_if_true1, [logical_test2…], [value_if_true2…]) | checks multiple conditions, returns first match | — |
| NOT | NOT(logical) | reverses the logic of its argument | 7 |
| OR | OR(logical…) | returns TRUE if any argument is true | 1 |
| SWITCH | SWITCH(expression, value1, result1, [default_or_value2…]) | evaluates expression against list of values | — |
| TRUE | TRUE() | returns the logical value TRUE | 15 |
| XOR | XOR(logical…) | returns exclusive or of all arguments | — |