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.