# Logical Functions

## Content

Spread provides the following logical functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [AND](/spreadjs/docs/v16/formulareference/FormulaFunctions/logical-functions/AND) | Check whether all arguments are True, and returns True if all arguments are True. |
| [FALSE](/spreadjs/docs/v16/formulareference/FormulaFunctions/logical-functions/FALSE) | This function returns the value for logical FALSE. |
| [IF](/spreadjs/docs/v16/formulareference/FormulaFunctions/logical-functions/IF) | This function performs a comparison and returns one of two provided values based on that comparison. |
| [IFERROR](/spreadjs/docs/v16/formulareference/FormulaFunctions/logical-functions/IFERROR) | This function evaluates a formula and returns a value you provide if there is an error or the formula result. |
| [IFNA](/spreadjs/docs/v16/formulareference/FormulaFunctions/logical-functions/IFNA) | This function returns the value you specify if the formula returns the #N/A error value, otherwise returns the result of the formula. |
| [IFS](/spreadjs/docs/v16/formulareference/FormulaFunctions/logical-functions/IFS) | This function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. |
| [NOT](/spreadjs/docs/v16/formulareference/FormulaFunctions/logical-functions/NOT) | This function reverses the logical value of its argument. |
| [OR](/spreadjs/docs/v16/formulareference/FormulaFunctions/logical-functions/OR) | This function calculates logical OR. It returns TRUE if any of its arguments are true; otherwise, returns FALSE if all arguments are false. |
| [SWITCH](/spreadjs/docs/v16/formulareference/FormulaFunctions/logical-functions/SWITCH) | This function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. |
| [TRUE](/spreadjs/docs/v16/formulareference/FormulaFunctions/logical-functions/TRUE) | This function returns the value for logical TRUE. |
| [XOR](/spreadjs/docs/v16/formulareference/FormulaFunctions/logical-functions/XOR) | This function returns a logical exclusive or of all arguments. |