Google Sheets-functie

XOR

Returns the exclusive OR of all arguments.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

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.

Argumenten

logical1vereistThe first condition or value you want to test.
logical2optioneelAdditional conditions or values to test, up to 254.

Voorbeelden

=XOR(TRUE, TRUE)

Resultaat: FALSE

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

=XOR(TRUE, FALSE, FALSE)

Resultaat: TRUE

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

Veelgestelde vragen

What happens if all arguments are FALSE?

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

Gerelateerde functies

AND OR NOT