The Excel Logical Functions are used for decision making calculations. The Logical Formulas in Excel can compare more than one conditions and return the result as True or False by evaluating the arguments in Excel Syntax.
Complete List of Excel Logical Functions (A to Z)
All Excel logical functions are mentioned below in alphabetical order:
| Function | Description |
| AND Function | Check if all conditions in a test are true. |
| BYCOL Function | Apply a LAMBDA function to each column and provides an array of the results. |
| BYROW Function | Apply a LAMBDA function to each row and provides an array of the results. |
| FALSE Function | FALSE as output. |
| IF Function | Logical comparison between a value and your expectation. |
| IFERROR Function | User defined value if a formula error occurs. |
| IFNA Function | User defined value if #N/A error occurs. |
| IFS Function | Evaluate one or more conditions and provide the value corresponds to the first true condition. |
| LAMBDA Function | Create a custom reusable function and can be called by a user friendly name. |
| LET Function | Define unique names to the calculation results. |
| MAKEARRAY Function | Array of a specified row and column size by using LAMBDA function. |
| MAP Function | An array formed by mapping each value in the array to a new value by using LAMBDA function. |
| NOT Function | Check whether one value is not equal to another value. |
| OR Function | Check whether one or more conditions are True, else results as False. |
| REDUCE Function | Reduce an array to an accumulated value by using LAMBAD function. |
| SCAN Function | Scan an array by using LAMBAD to each value and results an array having each itermediate value. |
| SWITCH Function | Compare one value with list of values and gets the result corresponds to the first matching value. |
| TRUE Function | TRUE as output. |
| XOR Function | TRUE if one condition is TRUE from multiple conditions, else results as FALSE. |