Google Sheets Functions: Logical

Find the list of all Google Sheets function tutorials on the Functions page.

Logical Functions

AND	Checks if all tests are TRUE.
BYCOL	Applies a LAMBDA function to each column of an array.
BYROW	Applies a LAMBDA function to each row of an array.
IF	Returns a value based on a condition.
IFERROR	Returns a value if there is no error or another value in case of an error.
IFS	Evaluates multiple conditions and displays the value corresponding to the first true condition.
LAMBDA	Creates and returns a custom function.
LET	Assigns names to values and then returns the result of a formula.
MAKEARRAY	Returns an array with specified dimensions with values calculated by a LAMBDA function.
MAP	Applies a LAMBDA function to each value in an array.
OR	Checks if at least one of the tests is TRUE.
REDUCE	Reduces an array to a cumulative result by applying a LAMBDA function.
SCAN	Scans an array and produces intermediate values by applying a LAMBDA function.