Thread: Looking for BOOLEAN ALGEBRA functions (specifically XOR)
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default 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)
Reply With QuoteReply With Quote