Logic.xla calculates an "if and only if" function, P Û Q
In logic, P
Û Q when P and Q have the same truth values.Syntax: "=IFOIF(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, values below P Û Q and P Û R were generated using the IFOIF function.
|
P |
Q |
R |
P Û Q |
P Û R |
|
TRUE |
TRUE |
1 |
TRUE |
TRUE |
|
FALSE |
TRUE |
1 |
FALSE |
FALSE |
|
TRUE |
FALSE |
0 |
FALSE |
FALSE |
|
FALSE |
FALSE |
0 |
TRUE |
TRUE |
Features|Logic Home|Logic Problem