Documentation/Calc Functions/XOR

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

XOR

Category:

Logical

Summary:

Returns true if an odd number of arguments evaluates to TRUE.

Syntax:

XOR(LogicalValue1; LogicalValue2 ...LogicalValue30)

Returns:

It return the boolean values either TRUE or FALSE according to the input argument.

Arguments:

The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values.

Additional details:

  • The arguments must evaluate to logical values such as TRUE or FALSE.
  • If the specified range contains no logical values, XOR returns the!Error511.
  • You can use an XOR array formula to see if a value occurs in an array.

Examples:

=XOR(TRUE;TRUE) returns FALSE

=XOR(TRUE;TRUE;TRUE) returns TRUE

=XOR(FALSE;TRUE) returns TRUE

XOR detailed all case scenario in an example

Related LibreOffice functions:

AND

OR

ODF standard:

Part 2, Section 6.15.10

Equivalent Excel functions:

XOR AND OR