Logical Functions
Last updated
Was this helpful?
Last updated
Was this helpful?
Logical functions perform logical operations or evaluate conditional statements and typically return boolean (true or false) output.
Determines if a value is within the specified range; True or False.
Given a specified index number, returns the matching value from a list.
Returns the first non-Null value from a list.
Evaluates if one or more conditions are true or false and returns the corresponding value.
Determines if a specified value matches any candidate values; True or False.
Determines if the cell has a value; True or False.
Determines if the cell is Null; True or False.
Using the SWITCH paradigm, tests the specified value against a list of conditions, and returns the matching response.
Returns non-Null values, or 0 (zero) instead of Null values.