Menu
EXCEL XOR FUNCTION
Excel XOR Function Introduction
The XOR Function was added in Excel 2013 and is found in the Excel Logical Functions section. It is a “exclusive OR” logical function. The XOR function returns TRUE if one of two provided logical propositions is true and FALSE if both statements are true. It also returns FALSE if none of the claims is true.
Description of Excel XOR Function
Syntax :
= XOR(logical1, [logical2],…)
Parameters :
- Logical1, logical2 – Logical1 is essential, while logical2 and following logical values are optional.
Step By Step Guide of XOR Function
Example :
If more than two logical assertions are found, the function will return:
- TRUE – When an odd number of arguments evaluate to TRUE.
- FALSE – When all assertions are false or the total number of TRUE statements is an even amount.
Key Points
- We may test up to 254 routines using the XOR Function.
- XOR disregards empty references.
- When no logical values are discovered, the #VALUE! error is returned.
- When using the function in Excel versions before to 2013, the #NAME! error will be returned.
- Parameters should be evaluated to logical values like TRUE or FALSE, or stored in arrays or references that hold logical values.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
