XOR Function in Excel 2013

This is a new function introduced in Excel 2013. We know that XOR is a logical function and to use this function in previous versions we had to use some complex statements.

Let's have a look at the following steps.

Step 1

First go to Excel 2013.

Step 2

Now select the blank workbook template from the available templates.


Step 3

Now enter the combination of True False values like this:


Step 4

Now write the following function to determine the XOR logical value like this:


Step 5

The output will be like this:


Step 6

As we already discussed, the XOR function is not available in previous versions of Microsoft Excel, it is however now available in the current (2013) version of Microsoft Excel. In previous versions of Excel we had to use some complex expressions to determine the XOR logical values like this:


Step 7

The output will be like this:


We can see that this makes no difference but we have to write the complex expression for this. Now Excel 2013 makes this easy for us using the XOR function.