[]
        
(Showing Draft Content)

XOR

This function returns logical exclusive OR of specified numbers.

Syntax

XOR(logical1, [logical2],…)

Arguments

This function has these arguments:

Argument

Description

logical1, logical2,…

logical 1 is required, subsequent logical values are optional. 1 to 254 conditions you want to test that can be either TRUE or FALSE, and can be logical values, arrays, or references.

Remarks

This function returns TRUE (or 1) when number of true inputs is odd; otherwise, returns FALSE (or 0) when number of true inputs is even.

Examples

XOR(3>0,2<9) gives the result FALSE