# Logical Functions

<table><thead><tr><th width="117">NAME</th><th width="309">SYNTAX</th><th>DESCRIPTION</th></tr></thead><tbody><tr><td><a href="logical-functions/if">IF</a></td><td>IF(logical_test, value_if_true, value_if_false)</td><td>Checks whether a condition is met and returns the first value if TRUE and second value if FALSE.</td></tr><tr><td><a href="logical-functions/switch">SWITCH</a></td><td>SWITCH(expression, value1, result1, value2, result2, ...,value_n, result_n, default?)</td><td>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.</td></tr><tr><td><a href="logical-functions/and">AND</a></td><td>AND(logical_test1,...logical_test2?)</td><td>Checks whether all the arguments are TRUE, and returns TRUE only if all the arguments are TRUE</td></tr><tr><td><a href="logical-functions/or">OR</a></td><td>OR(logical_test1,...logical_test2?)</td><td>Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all the arguments are FALSE</td></tr><tr><td><a href="logical-functions/not">NOT</a></td><td>NOT(logical_test)</td><td>Reverses FALSE to TRUE, or TRUE to FALSE</td></tr><tr><td><a href="logical-functions/xor">XOR</a></td><td>XOR(logical_test1,...logical_test2?)</td><td>Returns a logical 'Exclusive Or' of all the arguments</td></tr><tr><td><a href="logical-functions/ifnan">IFNAN</a></td><td>IFNAN(value1,value2?:number) - > number</td><td>Returns a default value if the value in the node is an error</td></tr></tbody></table>