# XOR

The XOR function returns a logical 'Exclusive Or' of all the arguments. XOR gives TRUE only when the conditions return different truth values.

| Arguments                                                           | Result |
| ------------------------------------------------------------------- | ------ |
| 1 or more test conditions return different results (TRUE and FALSE) | TRUE   |
| All the conditions are TRUE                                         | FALSE  |
| All the conditions are FALSE                                        | FALSE  |

### Syntax <a href="#syntax" id="syntax"></a>

```excel-formula
xor(logical_test1,[logical_test2],...)
```

### Arguments <a href="#arguments" id="arguments"></a>

logical\_test1 – The first condition to be evaluated. This is a required argument.

logical\_test2,.. – The additional conditions that are to be evaluated. These are optional arguments.

### **Return value** <a href="#return-value" id="return-value"></a>

Either True or False

### **Example** <a href="#example" id="example"></a>

```excel-formula
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.

### **Excel equivalent** <a href="#excel-equivalent" id="excel-equivalent"></a>

[XOR](https://support.microsoft.com/en-us/office/xor-function-1548d4c2-5e47-4f77-9a92-0533bba14f37)