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:

{0,0,1,1;
0,1,0,1}

which is in A1:D2.

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

and copy across.

Aladin