Thread
:
Looking for BOOLEAN ALGEBRA functions (specifically XOR)
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein
external usenet poster
Posts: 5,934
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.
Reply With Quote
Rick Rothstein
View Public Profile
Find all posts by Rick Rothstein