Logical functions

Logical functions perform logical operations or evaluate conditional statements and typically return boolean (true or false) output.

Function	Description
Between	Determines if a value is within the specified range; `True` or `False`.
Choose	Given a specified index number, returns the matching value from a list.
Coalesce	Returns the first non-Null value from a list.
If	Evaluates if one or more conditions are `true` or `false` and returns the corresponding value.
In	Determines if a specified value matches any candidate values; `True` or `False`.
IsNotNull	Determines if the cell has a value; `True` or `False`.
IsNull	Determines if the cell is Null; `True` or `False`.
Switch	Using the SWITCH paradigm, tests the specified value against a list of conditions, and returns the matching response.
Zn	Returns non-Null values, or 0 (zero) instead of Null values.