Logical functions
Logical functions perform logical operations or evaluate conditional statements and typically return boolean (true
or false
) output.
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. |
Updated 2 months ago