Logical Functions
Last updated
Last updated
| 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