Returns the exclusive OR of all arguments.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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)Результат: FALSE
Since there are two TRUE values (an even number), the result is FALSE.
=XOR(TRUE, FALSE, FALSE)Результат: 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.