# XOR

XOR(logical1 [,logical2] [..])

Returns the logical exclusive OR for any number of arguments.

 logical1 The first logical value or condition. logical2 (Optional) The second logical value or condition.

 REMARKS
 * This function returns either True or False.* This function is not case sensitive when matching text strings.* This function does not support wildcards (? and *).* This function will return True when the number of arguments that evaluate to True is odd.* This function will return False when the number of arguments that evaluate to True is even.* The logical values can be constants, logical equations, cell references or named ranges.* You can use this function to see if a value occurs in an array.* If any argument does not evaluate to either True or False, then #VALUE! is returned.* You can have a maximum of 254 arguments.* You can use the AND function to return the logical AND for any number of arguments.* You can use the IF function to return a value based on whether a condition is True or False.* You can use the NOT function to return the opposite of a True or False value.* You can use the OR function to return the logical OR for any number of arguments.* This function was added in Excel 2013.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A B 1 =XOR(TRUE) = -1 5 2 =XOR(FALSE) = 0 10 3 =XOR(TRUE, TRUE) = 0 some text 4 =XOR(FALSE, FALSE) = 0 5 =XOR(TRUE, TRUE, TRUE) = -1 6 =XOR(FALSE, FALSE, FALSE) = 0 7 =XOR(1, 1, 1, 1) = 0 8 =XOR(1, 1, 1, 1, 1) = -1 9 =XOR({TRUE}, {TRUE}) = 0 10 =XOR({TRUE, FALSE}) = -1 11 =XOR(1+1=2, 2+2=5) = -1 12 =XOR("SOME TEXT"="some text") = -1 13 =IF(XOR(B1>0, B2<20), "yes", "no") = no 14 =XOR("some text") = #VALUE!

 1 - What is the logical exclusive OR for True.2 - What is the logical exclusive OR for False.3 - What is the logical exclusive OR for True and True.4 - What is the logical exclusive OR for False and False.5 - What is the logical exclusive OR for True, True and True.6 - What is the logical exclusive OR for False, False and False.7 - What is the logical exclusive OR for the values 1,1,1 and 1.8 - What is the logical exclusive OR for the values 1,1,1,1 and 1.9 - What is the logical exclusive OR for two arrays containing the values True and True.10 - What is the logical exclusive OR for one array containing the values True and False.11 - What is the logical exclusive OR for the formulas (1+1=2) and (2+2=5).12 - What is the logical exclusive OR when comparing two text strings. This function is not case sensitive.13 - This function is often combined with the IF function.14 - This function returns #VALUE! if any arguments do not evaluate to True or False.

© 2024 Better Solutions Limited