Returns the exclusive OR of all arguments.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-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.