| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
Hi,
Excel doesn't have it but you can write your own quite simply =IF(COUNTIF(A1:B1,"Some Value")=1,TRUE,FALSE) Mike "RL Jones" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
Yes it could and until Excel include
=XOR(A1,B1) then they are as short as it gets. Mike "Rick Rothstein" wrote: 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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
... until Excel include =XOR(A1,B1)
It's included as an Excel vba function. I have no idea why it's not included as a Worksheet function. b = a Xor b = = = = Dana DeLouis Mike H wrote: Yes it could and until Excel include =XOR(A1,B1) then they are as short as it gets. Mike "Rick Rothstein" wrote: 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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
"Rick Rothstein" wrote...
Ah, yes... very good. And I guess that could be written this way as well... =NOT(A1)+NOT(B1)=1 .... If A1 and B1 would always be 1s or 0s, even shorter: =MOD(A1+B1,2) |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
Ah, yes... very good. And I guess that could be written this way as
well... =NOT(A1)+NOT(B1)=1 ... If A1 and B1 would always be 1s or 0s, even shorter: =MOD(A1+B1,2) Provided the user didn't need to see the result of the operation as TRUE/FALSE, of course. -- Rick (MVP - Excel) |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
On Tuesday, July 21, 2009 at 11:01:01 AM UTC-7, RL Jones wrote:
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. All you have to do is =not(a1 = a2) |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
textmonster404 wrote:
On Tuesday, July 21, 2009 at 11:01:01 AM UTC-7, RL Jones wrote: 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. All you have to do is =not(a1 = a2) All *you* have to do is check the date of the original post. I'm pretty sure "Jones" isn't still waiting for answers after almost ***EIGHT YEARS!!!*** -- I don't think you have yet told me how I can satisfy your curiosity. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recovering File Info Specifically Save Date or Print Date | Excel Discussion (Misc queries) | |||
| Compare Worksheet Templates-specifically validations, error messag | Excel Discussion (Misc queries) | |||
| Algebra | Excel Worksheet Functions | |||
| Sort a column (specifically email data) by end of text, not beginn | Excel Worksheet Functions | |||
| Time sheet set up specifically | New Users to Excel | |||
Hybrid Mode
