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 |