Formula to display xor value?

[koesherbacon]

How do I display an xor?

For instance, if I want cell P19 to display the value of K5 xor K7, what would the formula be?

 

[koesherbacon]

Note: These will be text and I'm using Office 2011 for OSX

 

[TheCman81]

Hi There,

Can you supply a little more info on what your data looks like and expected results.

But generally would be something like this

=IF(Criteria,K5,K7)

 

[koesherbacon]

I get a VALUE? error with that code.

You can check out my project here...
https://www.dropbox.com/s/qiqcllwdl0...%20Search.xlsx

And the MrExcel question to clarify some other questions I had here...
http://www.mrexcel.com/forum/excel-...ng-out-how-use-multiple-sheet-data-files.html

Thanks a ton, dude!

 

[mikerickson]

If K5 and K7 have logical values, =K5<>K7 will return the value of (K5 XOR K7)

If they contain something besides TRUE or FALSE, what do you mean by XOR?
Bit-wise logical operations on numbers like 5 OR 3 = 7 ?