Returns the exclusive OR of all arguments.
Ta funkcja działa w Arkuszach Google tak samo jak w Excelu — ta sama składnia i argumenty.
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.
=XOR(TRUE, TRUE)Wynik: FALSE
Since there are two TRUE values (an even number), the result is FALSE.
=XOR(TRUE, FALSE, FALSE)Wynik: TRUE
Since there is only one TRUE value (an odd number), the result is TRUE.
The XOR function will return FALSE because zero is an even number.