Tabular logic function XOR function

Returns the logical XOR of all parameters.

Grammar

XOR(logical1, [logical2],…)

The XOR function syntax has the following parameters.

Logical1, logical2, etc. Logical 1 is required, subsequent logical values ​​are optional.

1 to 254 conditions you want to test, which can be TRUE or FALSE and can be logical values, arrays, or references.

Description

The argument must evaluate to a logical value, such as TRUE or FALSE, or be an array or reference containing a logical value.

If the array or reference parameter contains text or blank cells, these values ​​will be ignored.

If the specified range does not contain a logical value, XOR returns the #VALUE! error value.

You can use the XOR array formula to check whether a value occurs in an array. To enter an array formula, press Ctrl+Shift+Enter.

When the number entered by TRUE is an odd number, the result of XOR is TRUE; when the number entered by TRUE is an even number, the result of XOR is FALSE.

Example