Functions Logical Copy page Copy as markdownThe page as text, ready for a chat View as markdown/docs/functions/logical-functions.md Ask Claude about this pageOpens Claude with this page's address Branch and combine conditions. FunctionWhat it does AND Returns TRUE if all arguments are true. EQ True when two values are equal. FALSE Returns the logical value FALSE. GT True when the first number is greater. GTE True when the first number is greater or equal. IF Returns one value if condition is true, another if false. IFERROR Returns value if no error, otherwise alternate. IFNA Returns value if not #N/A, otherwise alternate. IFS Checks multiple conditions, returns first match. ISBETWEEN True when a number lies within a range. LT True when the first number is smaller. LTE True when the first number is smaller or equal. NE True when two values differ. NOT Reverses the logic of its argument. OR Returns TRUE if any argument is true. SWITCH Evaluates expression against list of values. TRUE Returns the logical value TRUE. XOR Returns exclusive or of all arguments.
