... until Excel include =XOR(A1,B1)
It's included as an Excel vba function.
I have no idea why it's not included as a Worksheet function.
b = a Xor b
= = = =
Dana DeLouis
Mike H wrote:
Yes it could and until Excel include
=XOR(A1,B1) then they are as short as it gets.
Mike
"Rick Rothstein" wrote:
Ah, yes... very good. And I guess that could be written this way as well...
=NOT(A1)+NOT(B1)=1
--
Rick (MVP - Excel)
"Mike H" wrote in message
...
Rick,
Can be abbreviated to:-
=(A1<0)+(B1<0)=1
and it also works if both cells are blank.
Mike
"Rick Rothstein" wrote:
I'm pretty sure this is it...
=OR(AND(A1,NOT(B1)),AND(NOT(A1),B1))
--
Rick (MVP - Excel)
"RL Jones" <RL wrote in message
...
I am looking for BOOLEAN Algebra Functions. Can't find any help in
EXCEL.
While I can work around the OR, AND, and NOT, I need XOR.