Function: And, Or, Not

Logical functions

These functions are based on the Logical Operators.

Function	Syntax	Operator	Description	Example
And	And(Condition1, Condition2 [,Condition3 …])	&&	Returns true if all arguments are true.	And(TRUE, TRUE): True And(TRUE, FALSE): False And(FALSE, FALSE): False And(TRUE, TRUE, TRUE): True
Or	Or(Condition1, Condition2 [,Condition3 …])	||	Returns true if any of the arguments are true.	Or(TRUE, TRUE): True Or(TRUE, FALSE): True Or(FALSE, FALSE): False Or(FALSE, FALSE, TRUE): True
Not	Not(Condition)	!	Returns true if its arguments is false, and returns false if its argument is true.	Not(TRUE): False Not(FALSE): True Not(NOT(TRUE)): True