Home 
Search 
Today's Posts 
#1




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




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




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




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




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




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




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) 
#8




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) 
#9




Looking for BOOLEAN ALGEBRA functions (specifically XOR)
An XOR could operate on any number of binary bits.
An odd parity checker would XOR all given bits, thus checking for an odd number of bits in a word: =MOD(1+MOD(HEX2BIN("AE")1,9),2) I vote for Harlan's formulas, having lifted them from his post dated Jun 16, 2003. 
#10




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. 
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 Templatesspecifically 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 