How to use the XOR Function in Excel
Description
The XOR Function is categorized as Logical Function in Excel. This function is also called as Exclusive OR function. In this function you can use maximum of 254 conditions and each conditions evaluates as TRUE or FALSE. If there is odd number of TRUE within XOR function then it returns TRUE and if there is even number of TRUE or all the conditions are FALSE then it returns FALSE. It would be more easy to understand this function if you already learned and used OR function and AND Function.
The XOR function can take upto 254 arguments. It can also be used as a part of a formula.
Syntax
The syntax of IFNA function is =XOR(logical1,[logical2], ...)
Argument or Parameter
Logical1 (Required)- A condition, value or reference that evaluates TRUE or FALSE.
Logical1 (Optional) - A condition, value or reference that evaluates TRUE or FALSE.
- If you use 0 then it evaluates as FALSE
- If any number other than 0 then it evaluates as TRUE
Returns
The XOR function returns TRUE if it contains odd number of true and it returns FALSE if it contains even number of TRUE or all are FALSE.
Example
Example-1
Example-2
Example-3
Example-4
Notes
- In this function we can use upto 254 logicals
- Logicals can be a number, reference or expression.
********************************* ~:Support Our Work Financially:~ *********************************
Project File Type: Free
If you think this tutorial helps you to solve your problem and add value to your work, Buy me a Coffee..
************************************************************************************************
|
|
||||
| AND |
FALSE |
IF |
IFERROR |
IFNA |
|
NOT |
OR |
TRUE |
XOR |
|
0 Comments