XOR

The XOR function returns a logical exclusive OR of all arguments.

Syntax

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

Parameters

• logical1: The first condition to evaluate
• logical2, ...: Optional. Additional conditions to evaluate

Examples

=XOR(TRUE, FALSE) // Returns TRUE
=XOR(TRUE, TRUE) // Returns FALSE
=XOR(FALSE, FALSE) // Returns FALSE
=XOR(TRUE, FALSE, FALSE) // Returns TRUE