Google Sheets-funktion

XOR

Returns the exclusive OR of all arguments.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

XOR(logical1, [logical2], …)

The XOR function returns TRUE if an odd number of the provided arguments evaluate to TRUE, and FALSE otherwise. It is useful for determining if exactly one of several conditions is met.

Argument

logical1obligatorisktThe first condition or value you want to test.
logical2valfrittAdditional conditions or values to test, up to 254.

Exempel

=XOR(TRUE, TRUE)

Resultat: FALSE

Since there are two TRUE values (an even number), the result is FALSE.

=XOR(TRUE, FALSE, FALSE)

Resultat: TRUE

Since there is only one TRUE value (an odd number), the result is TRUE.

Vanliga frågor

What happens if all arguments are FALSE?

The XOR function will return FALSE because zero is an even number.

Relaterade funktioner

AND OR NOT