> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical.md).

# Logical Functions

- [AND](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/and.md): Returns true if all items are true, otherwise returns false
- [BETWEEN](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/between.md): Determines if given value is between two boundary values
- [CASE](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/case.md): Returns specified values when condition is met
- [CHOOSE](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/choose.md): Finds the value located at a specified index
- [CONTAINSWITHIN](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/containswithin.md): Returns true if the given value exists within a column or list of values.
- [IF](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/if.md): Tests whether expression is true or false and returns desired values accordingly
- [IFS](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/ifs.md): Implements multiple if-then statements simultaneously
- [IIF](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/iif.md): An if-then statement with capability of returning a third, unique value if condition is null
- [IN](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/in.md): Returns true if the given value exists within a column or list of values.
- [IFNULL](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/ifnull.md): Returns values dependent on if input values are null or not
- [ISBOOLEAN](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isboolean.md): Determine if given values are boolean
- [ISDECIMAL](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isdecimal.md): Determine if given values are decimals
- [ISDURATION](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isduration.md): Determine if given values are durations
- [ISINTEGER](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isinteger.md): Determine if given values are integers
- [ISNULL](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isnull.md): Returns true for null values and false otherwise
- [ISNUMBER](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isnumber.md): Determine if given values are numbers
- [ISSTRING](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isstring.md): Determine if given values are strings
- [ISUNIQUE](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/isunique.md): Determines if the values in a column are unique
- [NOT](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/not.md): Returns true when a condition is false and false otherwise
- [NULL](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/null.md): Returns null value
- [OR](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/or.md): Returns true if any of multiple conditions are true, otherwise returns false
- [SWITCH](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/switch.md): Switches values with new values if original value matches key
- [ALL](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/all.md): Determine if all elements of a column are true
- [TOSTRING](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/all/tostring.md): Convert a value into a string
- [ANY](https://docs.cascade.io/cascade/functions-and-expressions/functions/logical/any.md): Determine if any elements of a column are true