# Logical Functions

Logical functions perform logical operations or evaluate conditional statements and typically return boolean (`true` or `false`) output.

|                                                                                                                                            |                                                                                                                       |
| ------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------- |
| [between](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/between "mention")     | Determines if a value is within the specified range; `True` or `False`.                                               |
| [choose](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/choose "mention")       | Given a specified index number, returns the matching value from a list.                                               |
| [coalesce](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/coalesce "mention")   | Returns the first non-Null value from a list.                                                                         |
| [if](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/if "mention")               | Evaluates if one or more conditions are `true` or `false` and returns the corresponding value.                        |
| [in](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/in "mention")               | Determines if a specified value matches any candidate values; `True` or `False`.                                      |
| [isnotnull](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/isnotnull "mention") | Determines if the cell has a value; `True` or `False`.                                                                |
| [isnull](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/isnull "mention")       | Determines if the cell is Null; `True` or `False`.                                                                    |
| [switch](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/switch "mention")       | Using the SWITCH paradigm, tests the specified value against a list of conditions, and returns the matching response. |
| [zn](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/logical-functions/zn "mention")               | Returns non-Null values, or 0 (zero) instead of Null values.                                                          |