Logical(Microsoft Excel Functions)
It includes functions that return TRUE or FALSE mainly by evaluating logical expressions and functions that change the result by evaluating logical expressions.
Contents
- 1. Functions
- 1.1. Function that changes its value according to its logical value (the result of a logical expression)
- 1.2. Functions to manipulate logical values (results of logical expressions)
- 1.3. Functions that change the result depending on the value
- 1.4. LAMBDA functions to create custom functions and their helper functions
- 1.5. Other Logical Functions
Functions
Function that changes its value according to its logical value (the result of a logical expression)
| Function | Importance | Description |
|---|---|---|
| IF | High | Varying results depending on conditions. |
| IFS | High | Specify multiple conditions and get the value corresponding to the first matching condition. |
Functions to manipulate logical values (results of logical expressions)
| Function | Importance | Description |
|---|---|---|
| AND OR | High | Conditional judgment of logical and. Conditional judgment of logical or. |
| XOR | Low | Conditional judgment of exclusive or. |
| NOT | Middle | Invert the Boolean value. |
Functions that change the result depending on the value
| Function | Importance | Description |
|---|---|---|
| IFERROR IFNA | High | Sets the value if the formula is in error. |
| CHOOSE | Middle | Displays the corresponding value from 1 to 254. |
| SWICTH | High | Displays the first result matching the specified value. |
LAMBDA functions to create custom functions and their helper functions
| Function | Importance | Description |
|---|---|---|
| LAMBDA | High | Create custom functions. |
| MAP | Low | The range covered by the function is divided by cells to obtain individual results. |
| BYCOL | Low | The range covered by the function is divided by columns, and the aggregate results are obtained for each column. |
| BYROW | Low | The function divides the range covered by the function by rows and obtains the aggregate results for each row. |
| MAKEARRAY | Low | Create an array (cell range) with any number of rows and columns, and set individual cell values with any formulas. |
| ISOMITTED | Middle | Determines whether custom function arguments are set or omitted. The category is included in "Information Functions". |
| REDUCE | Low | Performs a cumulative calculation of any formula and obtains the result. |
| SCAN | Low | Creates a range of cells for the cumulative calculation of any formula. |
Other Logical Functions
| Function | Importance | Description |
|---|---|---|
| LET | High | Attach any name to the result of a formula. |