Extended Logic Function: Exor
Logic.xla calculates an "exclusive or" function, P Å Q


In logic, P Å Q Û (P Ú Q) L ~(P L Q)

Syntax: "=EXOR(argument1,argument2)",	
where argument1 and argument2 have a value of true or false.

Note: A value of 1 may be substituted for "TRUE" and 0 may be
substituted for "FALSE".  In the table below, Excel's built-in
logic functions were used to produce the values below the columns
labeled (P Ú Q), ~(P L Q),  and (P Ú Q) L ~(P L Q), where arguments are P and Q.
The values below P Å Q were generated using the EXOR function.

P

Q

(P Ú Q)

~(P L Q)

(P Ú Q) L ~(P L Q)

P Å Q

TRUE

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

TRUE

TRUE

TRUE

TRUE

TRUE

TRUE

FALSE

TRUE

TRUE

TRUE

TRUE

FALSE

FALSE

FALSE

TRUE

FALSE

FALSE


Features | Logic Home