LogicalLevel: IntermediateAvailable in: Excel 2013+

XOR returns TRUE when an odd number of conditions are TRUE — with two conditions, “one or the other but not both”.

Syntax

=XOR(logical1, [logical2], ...)

Examples

Example 1

=XOR(C2="Paid", D2<>"")

Flag inconsistent rows: marked Paid but no payment date, or a date but not marked Paid.

Related functions

AND · OR · NOT

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.