Logical Functions

NAME
SYNTAX
DESCRIPTION

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(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(logical_test1,...logical_test2?)

Checks whether all the arguments are TRUE, and returns TRUE only if all the arguments are TRUE

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(logical_test)

Reverses FALSE to TRUE, or TRUE to FALSE

XOR(logical_test1,...logical_test2?)

Returns a logical 'Exclusive Or' of all the arguments

IFNAN(value1,value2?:number) - > number

Returns a default value if the value in the node is an error

Last updated