Logical functions
| English | Description |
|---|---|
| AND | Returns TRUE if all of its arguments are TRUE |
| FALSE | Returns the logical value FALSE |
| IF | Specifies a logical test to perform |
| IFERROR | Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula |
| IFNA | Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression |
| IFS | Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition |
| NOT | Reverses the logic of its argument |
| OR | Returns TRUE if any argument is TRUE |
| SWITCH | Evaluates an expression against a list of values and returns the result corresponding to the first matching value If there is no match, an optional default value may be returned |
| TRUE | Returns the logical value TRUE |
| XOR | Returns a logical exclusive OR of all arguments |