Logical
12 functions in this section.
| AND | Returns TRUE if all parameters are TRUE and FALSE otherwise. |
| FALSE | Returns FALSE. |
| IF | Returns one of the given values based on logical conditions. |
| IFBLANK | Returns a value unchanged if it is not blank and a different value otherwise. |
| IFERROR | Returns a value unchanged if it is not an error and a different value otherwise. |
| IFNA | Returns a value unchanged if it is not an #N/A (not available) error and a different value otherwise. |
| IFS | Returns one of the given values based on logical conditions. |
| NOT | Negates the logical parameter and returns it. |
| OR | Returns TRUE if one or more values are TRUE and FALSE otherwise. |
| SWITCH | Tests a given parameter for equality against a list of parameters and returns a parameter associated with the parameter which matched the first parameter. |
| TRUE | Returns TRUE. |
| XOR | Returns TRUE if an odd number of parameters are TRUE and FALSE otherwise. |