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

Search
Clear search
Close search