XOR Function

[snd]

Hi to you all.
I'm new to Excel 2013.

This function puzzled me, I'll quote this from Excel Help:

"The result of XOR is TRUE when the number of TRUE inputs is odd and FALSE when the number of TRUE inputs is even." Then they gave an example:

Formula	Description	Result
=XOR(3>0,2<9)	Because one of the two tests evaluates to True, TRUE is returned.	TRUE

<thead>
</thead><tbody>
</tbody>

I applied it in an Excel cell and the result was "FALSE". Was their example wrong.

Thanks a lot.

 

[Rick Rothstein]

Okay, I concede that Excel's implementation of XOR makes sense, but I wish their description of the function was the cascading one (A Xor B Xor C Xor D, etc.) rather than an odd number of TRUE arguments (which, while identical, doesn't sound so). Given that, I guess the pre-2013 versions of Excel could use something like this...

=MOD(A1+B2+C3+D4+etc.,2)=1

as a substitute for, as an example, for this...

=XOR(A1,B2,C3,D4,etc.)...