XOR

LogicalExcel 2016

TRUE if an odd number of conditions are TRUE (exclusive or).

Syntax

XOR(logical1, [logical2], …)

Examples

=XOR(TRUE, FALSE)

→ TRUE

=XOR(TRUE, TRUE)

→ FALSE

Related functions

OR AND

More Logical functions

AND FALSE IF IFERROR IFNA IFS LAMBDA LET NOT OR SWITCH TRUE

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.