Logical Functions

Function

Description

AND

Returns TRUE if all arguments are true

FALSE

Returns the logical value FALSE

IF

Indicates the logical inquiry to be performed

IFERROR

Calculates a specified output if an expression contains an error; otherwise returns the result of the expression

NOT

Reverts the logical value of an argument

OR

Returns TRUE if one of the arguments is true

TRUE

Returns the logical value TRUE