Life is full of logical conditions. We wake up and we have two choices. Get out of the bed or again go to sleep.
Same is the case with our applications or programs in EXCEL which we create. Every decision is full of conditions which need to to fulfilled before the final execution.
But there are different types of conditions. Some are necessary and some are optional. So this article will be focusing on the conditions which are necessary i.e. have to be met at any cost for the execution of the program.
We are discussing about the XOR FUNCTION in EXCEL.
XOR FUNCTION RETURNS TRUE IF THE GIVEN CONDITIONS ARE OPPOSING TO EACH OTHER WHICH MEANS IF ONE CONDITION IS TRUE THEN OTHER MUST BE FALSE. XOR FUNCTION RETURNS A FALSE IF ALL THE CONDITIONS ARE SAME.
XOR function comes under the LOGICAL FUNCTIONS category in Excel.
It simply behaves like the binary XOR. [A separate section covers the information at the end of the article]
It checks if both the conditions are mismatch or not. [ It’ll return a false for both same conditions. Mismatch will result in True]
*The generalized statements mentioned above is only meant for TWO VARIABLES for the simplification purpose. Three variables will be discussed separately.
This article will discuss the purpose , syntax, use and examples of AND FUNCTION in EXCEL.
PURPOSE OF XOR IN EXCEL
XOR FUNCTION RETURNS TRUE IF THE CONDITIONS ARE MISMATCHED AND FALSE IF THE CONDITIONS ARE MATCHED. [TWO VARIABLES ONLY]
PREREQUISITES TO LEARN XOR
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Some information about the BINARY MATHEMATICS is an advantage for the use of such formulas.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Of course, Excel software.
SYNTAX: XOR FUNCTION
The Syntax for the function is
=XOR(CONDITION 1, CONDITION 2, CONDITION 3, …… SO ON)
CONDITION1 Any condition (e.g. if any cell>12)
CONDITION2 Any condition (if any cell <45)
Atleast TWO CONDITIONS are needed. At the most, any number of conditions can be used. [UPTO 254]
EXAMPLE:XOR FUNCTION IN EXCEL
|NUMBER 1||NUMBER 2|
STEPS TO USE XOR FUNCTION
- Select the cell where we want the result. For our example, we selected the cell H7.
- Put the expression for the given condition as =XOR((F7-G7)>30,(G7-F7)>30).
- Drag down the formula through the column.
- The result will appear correctly as shown in the picture above.
- The individual formula used is also shown.
We have taken the pair of 14 numbers in the sample above.
The condition for which the expression should be true is THE DIFFERENCE BETWEEN THE TWO NUMBERS SHOULD BE MORE THAN 30.
So for the first examples, we have put the function as =XOR((F7-G7)>30,(G7-F7)>30)
The function gives true when either of the condition is true. We have two conditions where one number is greater than the other by 30 or where the other number is greater than the first by 30.
So we put the function and the XOR FUNCTION suits perfectly and gives correct results.
BINARY XOR WITH THREE VARIABLES
As we know that just like AND FUNCTION, OR FUNCTION , XOR FUNCTION can have many inputs. We discussed the two inputs in details. Let us have a look at the three inputs.
The expression for the THREE INPUTS XOR WILL BE
The truth table for three input XOR is
OTHER WAYS TO REACH THIS ARTICLE
WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.