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 was added in Excel 2013.
* 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 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.
* 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.