Excel Function : XOR

Download now!

Excel Function : XOR




Returns a logical exclusive OR of all arguments

Microsoft Excel Reference Page


Syntax and Description of the XOR Excel Function

The syntax for the XOR function in Microsoft Excel is: XOR(logical1, [logical2], ...) where the logical1, logical2, ... arguments are 1 to 30 conditions you want to test that can be either TRUE or FALSE.

About XOR Excel Function

The XOR function in Excel returns the exclusive or of two values. The exclusive or of two values is 1 if the values are different, and 0 if the values are the same.