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

# Logical functions

> Browse Sigma logical functions available in formulas and calculations.

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

> Official documentation and guidance for using Sigma to build AI apps, dashboards, and agents on governed warehouse data.

## Docs

- [Between](https://help.sigmacomputing.com/docs/between.md): Use the Sigma Between function to check whether a value lies within a given range.
- [Choose](https://help.sigmacomputing.com/docs/choose.md): Use the Sigma Choose function to return the value at an index position from a list of inputs or a column.
- [Coalesce](https://help.sigmacomputing.com/docs/coalesce.md): Use the Sigma Coalesce function to return the value of the first argument that is not Null.
- [If](https://help.sigmacomputing.com/docs/if.md): Use the Sigma If function to return a value based on a conditional statement.
- [In](https://help.sigmacomputing.com/docs/in.md): Use the Sigma In function to test if a value matches any candidate value in a subsequent list of candidate values.
- [IsNotNull](https://help.sigmacomputing.com/docs/isnotnull.md): Use the Sigma IsNotNull function to return True if the argument does not contain missing data values, and False if the argument is Null (i.e..
- [IsNull](https://help.sigmacomputing.com/docs/isnull.md): Use the Sigma IsNull function to return True if the argument contains missing data values, and False if the argument is not Null (i.e., does not.
- [Switch](https://help.sigmacomputing.com/docs/switch.md): Use the Sigma Switch function to return the result corresponding to the first matching value.
- [Zn](https://help.sigmacomputing.com/docs/zn.md): Use the Sigma Zn function to return the argument value if it is not Null, otherwise returns zero.
- [NullIf](https://help.sigmacomputing.com/docs/nullif.md): Use the Sigma NullIf function to return Null if the first argument is equal to the second.