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