Excel Function : XOR

Download now!

Excel Function : XOR

Category

Logical

Description

Returns a logical exclusive OR of all arguments

Microsoft Excel Reference Page

https://support.office.com/en-us/article/XOR-function-1548d4c2-5e47-4f77-9a92-0533bba14f37

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.