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 or False

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 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