AND (Logical 1, Logical 2)
Checks whether all arguments are TRUE, and returns TRUE if all the arguments are TRUE.

FALSE ()
This function returns FALSE

IF (Logical Test, Result If True, [Result IF False])
Checks whether a condition is met, and returns one value if TRUE and another value if FALSE

IFERROR (value, Value If Error)
Returns value_if_error if the first expression is an error and the value of the expression itself otherwise.

NOT ()
Returns the opposite of the argument

OR (Logical 1, Logical 2)
Returns TRUE if any of the arguments are TRUE and returns FALSE if all the arguments are FALSE.

SWITCH (Expression, Value 1, Result 1, …., [Else])
Returns different results depending on the value of an expression

TRUE ()
Returns TRUE