View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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)