Returns TRUE when only one condition is true.
The Excel XOR (exclusive OR) function is a logical operator which return TRUE when only one of the logic or condition is true.
Don’t confuse, OR function return TRUE when at least one of the logic is true whereas XOR function returns TRUE if only one is right.
= XOR(logical1, [logical2],…)
logical1 -The first criteria to evaluate
logical2 [optional] – Additional criteria to test, up to a maximum of 255 criteria.
Logical value TRUE or FALSE
The XOR function returns TRUE if only one criterion (exclusive OR) is true and return FALSE in case more than one or none of the logic is true among all the conditions.
Empty or Blank cell arguments are considered FALSE.