returns exclusive or of all arguments · from excel · excel: not yet compared · sheets: not yet compared

signature

XOR(logical…)

returns: boolean

argument	required
logical…	required

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

related

• AND returns TRUE if all arguments are true
• EQ true when two values are equal
• FALSE returns the logical value FALSE
• GT true when the first number is greater
• GTE true when the first number is greater or equal
• IF returns one value if condition is true, another if false