Boolean Logical Operators Truth Table
Boolean logical operators is just a fancy name for the language used to combine multiple condition formulas into a single condition formula or, in the case of the
NOT() function, reverse the results of a condition formula.
NOT() have similar meanings as in conversational English. Both
a AND b need to be true for the result to be true. Either
a OR b can be true for its result to be true.
NOT(b) is only true if b is false.
The rest of the Boolean Logical Operators can all be created by combining those three operators. For example,
a NOR b is the same as
NOT(a OR b), but it is shorter to write using
The following true table explains the results when different combinations of true and false formulas are used as the inputs of the various logical operators.
||Not Inclusive Or||False||False||True|
||Not Exclusive Or||True||False||True|
b are both Boolean formulas (returning true or false).
The order of
b do not matter.
NOT() function just takes one Boolean formula and reverses its result. This is why it does not have a result listed for Mixed.