XOR
The XOR function returns a logical 'Exclusive Or' of all the arguments.
Syntax
xor ( logical_test1, [logical_test2], ... )Arguments
logical_test1 – The first condition to be evaluated. This is a required argument.
logical_test2,.. – The additional conditions to be evaluated. These are optional arguments.
Return value
Either True or False
Example
if(xor(Region == "West", Category=="Urban"), 25, 30)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