Returns a blank value.
Logical value true. The value of true is represented numerically by a 1.
Logical value false. False is represented numerically by a 0.
Returns true if all the arguments are true, returns false otherwise.
Returns true if any one of the arguments is true.
Reverses the logical value of its argument.
Returns true if an odd number of arguments are true.
Returns value1 if the logical argument is true, otherwise it returns value2. Can also be used to make nested IF statements.
Can also be used to check if a cell is blank/is empty.
Takes an expression, a list of possible values for that expression, and for each one, a value that the expression should take in that case. It can also take a default value if the expression input doesn't match any of the defined patterns. In many cases, SWITCH() can be used instead of a nested IF() formula.