View Single Post
  #7   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)