8 Logical Functions

Here is the list of the logical functions, please click each function to see more details.

FunctionFormula
AND FunctionAnd(Logical1, [Logical2], …)
FALSE FunctionFalse()
IF FunctionIf(Logical_Test, Value_If_True, [Value_If_False])
IFERROR FunctionIferror(Value, Value_If_Error)
IFNA FunctionIfna(Value, Value_If_Na)
NOT FunctionNot(Logical)
OR FunctionOr(Logical1, [Logical2], …)
TRUE FunctionTrue()