Logical Functions

AND

Returns TRUE if all of its arguments are TRUE

FALSE

Returns the logical value FALSE

IF

Specifies a logical test to perform

IFERROR

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula

IFNA

Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression

IFS

Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

NOT

Reverses the logic of its argument

OR

Returns TRUE if any argument is TRUE

SWITCH

Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.

TRUE

Returns the logical value TRUE

XOR

Returns a logical exclusive OR of all arguments