XOR

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

Returns the logical exclusive OR for any number of arguments.

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

REMARKS
* 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 (not 255).
* 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

 AB
1=XOR(TRUE) = -15
2=XOR(FALSE) = 010
3=XOR(TRUE,TRUE) = 0some 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.

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top