MrExcel Publishing
Your One Stop for Excel Tips & Solutions

XOR as a function

Posted by russ on January 18, 2002 9:57 AM

Where is it OR How can I get it as a function?

Posted by Aladin Akyurek on January 18, 2002 1:18 PM

There isn't one. Maybe some would want to write up in VBA.

However, what follows might be of some use to you:

Lets take the following sample:


which is in A1:D2.

In A4 enter: =OR(AND(A1,NOT(A2)),AND(A2,NOT(A1)))

and copy across.