GREAT! especially latter one.

Thanks Chip.

---------------------------------
This can be shortened to

=(A1<0)+(A2<0)=1


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

"Chip Pearson" wrote in message
...
You can use the following formula to XOR cells A1 and A2.

=OR(AND(A1,NOT(A2)),AND(A2,NOT(A1)))

An expanded version handles the case when either A1 or A2 is empty:

=IF(OR(A1="",A2=""),NA(), OR(AND(A1,NOT(A2)),AND(A2,NOT(A1))))


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


"lurchot" wrote in message
...
dear all,

In excel, it seem that XOR operator is not supported by default, are
there any other ways to work around?

Thanks.
lurchot