# Logical Functions

## Content

DsExcel.NET provides the following logical functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [AND](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/and) | Check whether all arguments are True, and returns True if all arguments are True. |
| [BYCOL](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/bycol) | This function applies a LAMBDA to each column and returns an array of the results. |
| [BYROW](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/byrow) | This function applies a LAMBDA to each row and returns an array of the results. |
| [FALSE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/false) | This function returns the value for logical FALSE. |
| [IF](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/if) | This function performs a comparison and returns one of two provided values based on that comparison. |
| [IFERROR](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/iferror) | This function evaluates a formula and returns a value you provide if there is an error or the formula result. |
| [IFNA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/ifs) | This function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. |
| [LAMBDA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/lambda) | This function allows you to create and name custom reusable functions that can be called like any other function. |
| [MAKEARRAY](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/-makearray) | This function returns a calculated array of a specified row and column size, by applying a LAMBDA function. |
| [MAP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/map) | This function returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value. |
| [NOT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/not) | This function reverses the logical value of its argument. |
| [OR](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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. |
| [REDUCE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/reduce) | This function reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator. |
| [SCAN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/scan) | This function scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value. |
| [SWITCH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/true) | This function returns the value for logical TRUE. |
| [XOR](/document-solutions/dot-net-excel-api/docs/online/formula-reference/logical-functions/xor) | This function returns a logical exclusive or of all arguments. |