| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XOR operator in Excel
dear all,
In excel, it seem that XOR operator is not supported by default, are there any other ways to work around? Thanks. lurchot |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XOR operator in Excel
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XOR operator in Excel
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XOR operator in Excel
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XOR operator in Excel
What version of Excel does not support Xor ? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XOR operator in Excel
What version of Excel does not support Xor ?
I would assume that he was speaking of a worksheet function, not the VBA operator. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2008 Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Jim Cone" wrote in message ... What version of Excel does not support Xor ? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XOR operator in Excel
Thanks Chip. I guess I got up too early. -- Jim Cone "Chip Pearson" wrote in message What version of Excel does not support Xor ? I would assume that he was speaking of a worksheet function, not the VBA operator. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2008 Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Jim Cone" wrote in message What version of Excel does not support Xor ? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have Excel retrieve conditional operator ( < = ) from a cell | Excel Worksheet Functions | |||
| Operator | Excel Worksheet Functions | |||
| MAJOR BUG: Excel operator precedence is wrong | Excel Worksheet Functions | |||
| what does ~ operator mean? | Excel Discussion (Misc queries) | |||
| Or operator | Excel Worksheet Functions | |||
Hybrid Mode
