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