Documentation/Calc Functions/XOR

Function name:
XOR

Category:
Logical

Summary:
Performs a logical "exclusive or" (XOR) operation on multiple conditions. The result is TRUE if and only if an odd number of the specified conditions are true and FALSE otherwise.

Syntax:
XOR(Logical Value 1 [; Logical Value 2 [; … [; Logical Value 255]]])

Returns:
Returns the logical value TRUE if an odd number of the supplied conditions are met and returns the logical value FALSE when an even number of the supplied conditions are met.

Arguments:
Logical Value 1, Logical Value 2, …, Logical Value 255 give the set of conditions to be checked. Each condition should comprise an expression that evaluates to give a logical value that is either TRUE or FALSE. If an expression evaluates to a number instead of a logical value, then the value 0 (zero) is treated as FALSE and all non-zero values are treated as TRUE. Each argument may take one of the following forms:


 * A logical value, or an expression that can be evaluated to a logical value. Examples include TRUE, 3, 1<5, 2+3=7, A2*A3, and B8<10.
 * A reference to a single cell containing a logical value or expression.
 * A reference to a cell range containing logical values or expressions (for example, D6:E12 or A1:B9~E12:E14).
 * The name of a named range, comprising cells containing logical values or expressions.
 * The name of a database range, comprising cells containing logical values or expressions.
 * An inline array of logical values or numbers (for example {TRUE, FALSE, 0, 123.456}).

Note that although XOR can accept up to 255 arguments, each argument could specify a range of cells. This means that the number of conditions processed could be many more than 255.


 * If the arguments do not give at least one logical value, then XOR reports a #VALUE! error.
 * If the arguments give exactly one value, then XOR returns that logical value.
 * If any argument is a string in quotation marks, then XOR reports a #VALUE! error. This does not apply to references to cells containing strings.
 * Empty cells and cells that contain text are ignored by XOR.
 * If a cell contains an error value, then XOR propagates that error irrespective of the content of other cells.

Details specific to XOR function

 * In its simplest form, the logical XOR (sometimes known as exclusive or, or exclusive disjunction) of two logical values is an operation that produces a value of true if exactly one of its operands is true and false otherwise. It can be expressed as a truth table as follows:


 * XOR ignores any text in cells or empty cells. If you suspect wrong results, look for text within the supplied data range(s). To highlight text content within a data range, use Calc's feature.

Related LibreOffice functions:
AND

Special:MyLanguage/Documentation/Calc_Functions/FALSE

IF

IFERROR

IFNA

IFS

NOT

OR

SWITCH

Special:MyLanguage/Documentation/Calc_Functions/TRUE

ODF standard:
Section 6.15.10, part 2

Equivalent Excel functions:
XOR