Logical Functions


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.


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


Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all the arguments are FALSE


Reverses FALSE to TRUE, or TRUE to FALSE


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