WeCodeAcademy
❮ NOTISNUMBER ❯

XOR

True when an odd number of conditions are true. With two conditions: exactly one.

Group: Logical

Syntax

XOR(test1, [test2], ...)

Example

Exampleexcel
Open in editor »

← All of Excel Function Reference