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.