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.