XOR Function in Excel: We all know that Excel is a great spreadsheet program that helps to perform huge mathematical calculations within a second using its built-in formulas and functions. On that note, we can easily use the functions to perform logical calculations too. XOR is one of the logical operations that returns the value TRUE if both the arguments are different. Otherwise, it returns the value FALSE.
In case, you want to apply this function on your spreadsheet and don’t know how to do it? then we will help you. Don’t worry. This article gives you the outline of the explanation, syntax, and usage of the XOR function in Excel. Get the official version of MS Excel from the following link:
https://www.microsoft.com/en-in/microsoft-365/excel
Description of XOR Function
- It is one of the built-in functions in Microsoft Excel.
- XOR is one of the logical operations that returns the value TRUE if both the arguments are different. Otherwise, it returns the value FALSE.
- You can refer to the below table to understand the function of XOR. Here, the boolean value 0 represents FALSE and 1 represents TRUE.
| 0 | 1 | 1 |
| 0 | 0 | 0 |
| 1 | 1 | 0 |
| 1 | 0 | 1 |
Syntax
- Here, you will see the syntax of the XOR function.
- To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
- Once you enter the formula, just click on the Enter button to get the result.
=XOR(logical1, [logical2], …)
Argument Description
- logical1 – It can be an expression, constant, or reference that evaluates to TRUE or FALSE.
- logical2 – This is an optional one. It refers to an expression, constant, or reference that evaluates to TRUE or FALSE.
Practical Examples
Now let’s grasp some examples of the XOR function and explore how it works in Microsoft Excel.
- Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
- For example, we have given input boolean values in cells B3:C4, as shown in the below image.
- Then, we have to apply the above-mentioned formula and hit the Enter button in order to get the result.
- Once you have executed the formula, you will get the result, as shown in the following screenshot.
- As we said earlier, this function returns the value TRUE if both the arguments are different. Otherwise, it returns the value FALSE.
- Let’s see one more example to make it clear. In the following example, we have shown two input values in Cells B3:C4.
- We will apply expressions to the formula in order to get the output. Refer to the below image.
- After executing the formula, you will get the result, as shown in the below image.
Closure
In this short article, we have described the explanation, syntax, and usage of the XOR Function with a few practical examples. Hope it is useful to you. Drop your worthwhile feedback in the below comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
Video Tutorial
This video will show you how to apply the XOR function in the Excel spreadsheet and get the result.
Also Read:
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Deepak is an Excel enthusiast and data analyst with over 5 years of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!
