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.
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
IFNAN(value1,value2?:number) - > number
Returns a default value if the value in the node is an error
Last updated