logical functions
branch and combine conditions.
| function | signature | what it does | tests |
|---|---|---|---|
| AND | AND(logical…) | returns TRUE if all arguments are true | 28 |
| EQ | EQ(value1, value2) | true when two values are equal | — |
| FALSE | FALSE() | returns the logical value FALSE | 13 |
| GT | GT(value1, value2) | true when the first number is greater | — |
| GTE | GTE(value1, value2) | true when the first number is greater or equal | — |
| 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 | — |
| ISBETWEEN | ISBETWEEN(value, low, high, [low_inclusive], [high_inclusive]) | true when a number lies within a range | — |
| LT | LT(value1, value2) | true when the first number is smaller | — |
| LTE | LTE(value1, value2) | true when the first number is smaller or equal | — |
| NE | NE(value1, value2) | true when two values differ | — |
| NOT | NOT(logical) | reverses the logic of its argument | 8 |
| 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 | — |