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.