Excel Functions: Logical

Find the list of all Excel function tutorials on the page Excel Functions.

Logical Functions

ANDChecks if all tests are TRUE.
BYCOLApplies a LAMBDA function to each column and returns an array of the results.
BYROWApplies a LAMBDA function to each row and returns an array of the results.
IFChecks if a condition is met and returns a value based on that condition.
IFSChecks if multiple conditions are met and returns a value corresponding to the first true condition.
IFERRORReturns a value if there is no error or another value in case of error.
LAMBDACreates a custom function.
LETAssigns a name to calculation results.
MAKEARRAYReturns an array of specified dimensions by applying a LAMBDA function.
MAPReturns an array after applying a LAMBDA function.
ORChecks if at least one of the tests is TRUE.
REDUCEReduces an array to a cumulative value by applying a LAMBDA function.
SCANTraverses the values of an array, applies a LAMBDA function and returns an array of intermediate values.