XOR

INFO

This page was originally generated from official documentation.

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

Syntax

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
2	TRUE
3	FALSE
4	FALSE
5	TRUE
6	TRUE

A	B	C	D
9	logical_expression1	logical_expression2	Result
10	TRUE	FALSE	TRUE
11	FALSE	FALSE	FALSE
12	TRUE	TRUE	FALSE
13	0	1	TRUE
14	1	5	FALSE

A	B
17	Result
18	FALSE
19	FALSE
20	TRUE

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.