> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Logical functions

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

| Function                     | Description                                                                                                           |
| ---------------------------- | --------------------------------------------------------------------------------------------------------------------- |
| [Between](/docs/between)     | Determines if a value is within the specified range; `True` or `False`.                                               |
| [Choose](/docs/choose)       | Given a specified index number, returns the matching value from a list.                                               |
| [Coalesce](/docs/coalesce)   | Returns the first non-Null value from a list.                                                                         |
| [If](/docs/if)               | Evaluates if one or more conditions are `true` or `false` and returns the corresponding value.                        |
| [In](/docs/in)               | Determines if a specified value matches any candidate values; `True` or `False`.                                      |
| [IsNotNull](/docs/isnotnull) | Determines if the cell has a value; `True` or `False`.                                                                |
| [IsNull](/docs/isnull)       | Determines if the cell is Null; `True` or `False`.                                                                    |
| [Switch](/docs/switch)       | Using the SWITCH paradigm, tests the specified value against a list of conditions, and returns the matching response. |
| [Zn](/docs/zn)               | Returns non-Null values, or 0 (zero) instead of Null values.                                                          |