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 |
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.