Excel XOR function

Function              XOR

Description        Excel XOR function performs exclusive OR and returns TRUE or FALSE.

Syntax  XOR(logical1, [logical2], …)

logical1  The first condition or logical value to evaluate.

logical2  [optional] The second condition or logical value to evaluate.

XOR means it will return only TRUE when only one of them is TRUE. XOR returns FALSE in both cases when both are TRUE or both are FALSE.