XOR

Returns TRUE if an odd number of arguments are TRUE, and FALSE otherwise

Syntax

XOR(logical1, [logical_n])

Arguments

Argument	Description	Required
logical1	The first logical value or expression to evaluate	Required
logical_n	Additional logical values or expressions to evaluate	Optional

Examples

XOR with one TRUE and one FALSE

XOR with two TRUE values

XOR with three TRUE values (odd number)

XOR with single TRUE value

Related Functions

Other Logical functions:

• AND - Returns true if all arguments evaluate to true
• CONTAINS - Returns true if a range contains a specified value
• IF - Returns the first value if logical_expression is TRUE; otherwise returns the second value.
• IFERROR - Returns a custom result when a formula generates an error, and a normal result when no error is detected.
• IFS - Returns the value corresponding to the first TRUE result when evaluating multiple tests.
• ISBETWEEN - Returns true if a provided number is between two other numbers either inclusively or exclusively; otherwise returns false.
• ISBLANK - Returns true if the value is blank, empty, or null; otherwise returns false.
• ISERROR - Returns TRUE if the value is any error value
• ISEVEN - Returns TRUE if the number is even, FALSE if odd
• ISNA - Returns TRUE if the value is the #N/A error value
• ISNUMBER - Returns TRUE if the value is a number
• ISODD - Returns TRUE if the number is odd, FALSE if even
• ISTEXT - Returns TRUE if the value is text
• NOT - Returns FALSE if logical expression is TRUE and TRUE if logical expression is FALSE.
• OR - Returns true if any argument evaluates to true
• SWITCH - Evaluates an expression against a list of values and returns the result corresponding to the first matching value. Optionally returns a default value if no match is found.

---

← Back to Formula Reference