[Rick Rothstein]

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.