Posted to microsoft.public.excel.worksheet.functions
|
|
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
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.
|