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.

 

[GTO]

I am afraid I am limited to Excel2010 and the exclusive or did not exist as a worksheet function until 2013. I read the online help it seems awfully confusing. I would think that "The result of XOR is TRUE when the number of TRUE inputs is odd and FALSE when the number of TRUE inputs is even." would be accurate.

Just out of curiosity, what happens if you put =XOR(10,8) in a cell?

Mark

 

[godsaaint]

I am afraid I am limited to Excel2010 and the exclusive or did not exist as a worksheet function until 2013. I read the online help it seems awfully confusing. I would think that "The result of XOR is TRUE when the number of TRUE inputs is odd and FALSE when the number of TRUE inputs is even." would be accurate.

Just out of curiosity, what happens if you put =XOR(10,8) in a cell?

Mark

It returns FALSE since you are providing an even amount of numbers. Had it been =XOR(10) or =XOR(10,8,5), it would return TRUE.

 

[GTO]

Thank you godsaaint.

Mark

 

[snd]

Thanks Mark for your answer.

 

[snd]

Thanks godsaaint for your answer.

 

[chicagocomputerclasses]

This should be equivalent to the one below, but strangely it doesn't work that way.

	A
1	=ISODD(SUMPRODUCT(--{FALSE,TRUE,FALSE,TRUE,TRUE}))
Sheet2

<tbody>
</tbody>

 

[chicagocomputerclasses]

Now that I'm thinking about it more, it is actually equivalent.

 

[GTO]

This should be equivalent to the one below, but strangely it doesn't work that way.

	A
1	=ISODD(SUMPRODUCT(--{FALSE,TRUE,FALSE,TRUE,TRUE}))
Sheet2

<tbody>
</tbody>

That does not return TRUE for you?

 

[chicagocomputerclasses]

Actually it does. It works exactly the same. I just made a mistake in my SUMPRODUCT ARRAY when I was testing it.

So yes those 2 will return exactly the same results.