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.

xorfunctionofexcel2013.jpg

Step 3

Now enter the combination of True False values like this:

xorfunctioninexcel.jpg

Step 4

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

xorfunctioninexcel2013.jpg

Step 5

The output will be like this:

excel2013xorfunction.jpg

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:

excelxorfunction1.jpg

Step 7

The output will be like this:

xorfunctionofexcel2013.jpg

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.

Up Next
    Ebook Download
    View all
    Learn
    View all