Logical Functions

NAME	SYNTAX	DESCRIPTION
IF	IF(logical_test, value_if_true, value_if_false)	Checks whether a condition is met and returns the first value if TRUE and second value if FALSE.
SWITCH	SWITCH(expression, value1, result1, value2, result2, ...,value_n, result_n, default?)	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 is returned.
AND	AND(logical_test1,...logical_test2?)	Checks whether all the arguments are TRUE, and returns TRUE only if all the arguments are TRUE
OR	OR(logical_test1,...logical_test2?)	Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all the arguments are FALSE
NOT	NOT(logical_test)	Reverses FALSE to TRUE, or TRUE to FALSE
XOR	XOR(logical_test1,...logical_test2?)	Returns a logical 'Exclusive Or' of all the arguments
IFNAN	IFNAN(value1,value2?:number) - > number	Returns a default value if the value in the node is an error