XOR
The XOR function returns a logical 'Exclusive Or' of all the arguments. XOR gives TRUE only when the conditions return different truth values.
Arguments | Result |
---|---|
1 or more test conditions return different results (TRUE and FALSE) | TRUE |
All the conditions are TRUE | FALSE |
All the conditions are FALSE | FALSE |
Syntax
Arguments
logical_test1 – The first condition to be evaluated. This is a required argument.
logical_test2,.. – The additional conditions that are to be evaluated. These are optional arguments.
Return value
Either True or False
Example
Returns 25 for all categories in the West except for category Urban, and for all Urban categories except for region West; for all other items, returns 30.
Excel equivalent
Last updated