Select Page

Function Index

Logical Functions

Logical functions test for True/False values. They evaluate a condition, and return a value based on whether the condition is True or False.

Returns the value with the corresponding index position. When an index number is provided and a corresponding value does not exist, a Null result is returned.
Returns the first non-Null value from the arguments provided.
Returns the value following the first condition that is met.
Test if a value matches any value in a subsequent list of values. Returns True if the first value matches any of the subsequent values. Returns False if no values are matched.
Returns True if the argument contains valid data, and False if the argument is Null (does not contain valid data).
Returns True if the argument is Null (does not contain valid data), and False otherwise.
Returns the result corresponding to the first matching value.

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.