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;
True
orFalse
- 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;
True
orFalse
- IsNotNull
- Determines if the cell has a value;
True
orFalse
- IsNull
- Determines if the cell is Null;
True
orFalse
- 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