ExcelHeroThe XOR function
TRUE when exactly one of the tests is true (with two tests).
In German Excel: XODER
How to write it
=XOR(logical1, [logical2], …)- logical1
- The first test.
- logical2
- More tests.
💡 With more than two tests, XOR is TRUE when an odd number of them are true.
Try it
Did exactly one of the two shops reach 100 sales?
A
B
C
1
Shop A
Shop B
Only one?
2
120
95
=XOR(test one, test two) is TRUE when exactly one of them is.