Excel Functions: Logical
Find the list of all Excel function tutorials on the page Excel Functions.
Logical Functions
AND | Checks if all tests are TRUE. |
BYCOL | Applies a LAMBDA function to each column and returns an array of the results. |
BYROW | Applies a LAMBDA function to each row and returns an array of the results. |
IF | Checks if a condition is met and returns a value based on that condition. |
IFS | Checks if multiple conditions are met and returns a value corresponding to the first true condition. |
IFERROR | Returns a value if there is no error or another value in case of error. |
LAMBDA | Creates a custom function. |
LET | Assigns a name to calculation results. |
MAKEARRAY | Returns an array of specified dimensions by applying a LAMBDA function. |
MAP | Returns an array after applying a LAMBDA function. |
OR | Checks if at least one of the tests is TRUE. |
REDUCE | Reduces an array to a cumulative value by applying a LAMBDA function. |
SCAN | Traverses the values of an array, applies a LAMBDA function and returns an array of intermediate values. |