Whereas the OR function returns true ifanyinput is TRUE, XOR only returns TRUE in specific cases.
If both values are TRUE, XOR returns FALSE.
The concept of exclusive OR is more common in the world of programming.
If they visit one or the other, the original statement is TRUE.
If they visit neither or both, the original statement is FALSE.
OR returns TRUEif any condition is TRUE.
If all conditions are FALSE, the OR function returns FALSE.
When given TRUE, NOT returns FALSE.
When given FALSE, NOT returns TRUE.
Use the NOT function to reverse a logical value.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
More than one condition can be tested by nesting IF functions.
