XOR function

The XOR function returns TRUE if an odd number of the provided arguments are logically true, and FALSE otherwise.

Parts of a XOR formula

XOR(logical_expression1, [logical_expression2, ...])

Part	Description	Notes
logical_expression1	An expression or reference to a cell containing an expression that represents some logical value, e.g. "TRUE" or "FALSE," or an expression that can be coerced to a logical value.
logical_expression2	More expressions or cell references that represent logical values.	A second logical expression, and any additional expressions are optional.

Sample formulas

XOR(TRUE, FALSE, TRUE)

XOR(A2=TRUE, A3=FALSE)

XOR(A1:A10, B1:B10)

XOR(0, 1, 2, 3)

Notes

• The number 0 is logically false. All other numbers (including negative numbers) are logically true.
• The XOR function accepts both logical value and range parameters.
• Returns TRUE if an odd number of arguments are TRUE.

Examples

	A	B
1	Result	Formula
2	TRUE	=XOR(TRUE())
3	FALSE	=XOR(FALSE())
4	FALSE	=XOR(0)
5	TRUE	=XOR(1)
6	TRUE	=XOR(-3)

 

 

	A	B	C	D
9	logical_expression1	logical_expression2	Result	Formula
10	TRUE	FALSE	TRUE	=XOR(A10,B10)
11	FALSE	FALSE	FALSE	=XOR(A11,B11)
12	TRUE	TRUE	FALSE	=XOR(A12,B12)
13	0	1	TRUE	=XOR(A13,B13)
14	1	5	FALSE	=XOR(A14,B14)

 

 

	A	B
17	Result	Formula
18	FALSE	=XOR(A12,B13)
19	FALSE	=XOR(B11,B12,B13)
20	TRUE	=XOR(B11,B14)

Related functions

• OR: The OR function returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.
• AND: The AND function returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.