Logical functions overview
Logical functions test if a condition is valid; they usually evaluate to True or False values.
Sigma supports the following logical functions:
- Between
- Determines if a value is within the specified range;
TrueorFalse - Choose
- Provided a specified index number, returns the matching value from a list
- Coalesce
- Returns the first non-Null value from a list
- If
- Using the IF .. THEN .. ELSE paradigm, tests the specified value against a single condition, and returns the matching response
- In
- Determines if a specified value matches any candidate values;
TrueorFalse - IsNotNull
- Determines if the cell has a value;
TrueorFalse - IsNull
- Determines if the cell is Null;
TrueorFalse - 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 5 months ago