View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] textmonster404@gmail.com is offline
external usenet poster
 
Posts: 1
Default Looking for BOOLEAN ALGEBRA functions (specifically XOR)

On Tuesday, July 21, 2009 at 11:01:01 AM UTC-7, 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.


All you have to do is
=not(a1 = a2)