XOR Function

The XOR function is one of the logical functions. It is used to return a logical Exclusive Or of all arguments. The function returns TRUE when the number of TRUE inputs is odd and FALSE when the number of TRUE inputs is even.

Syntax

XOR(logical1, [logical2], ...)

The XOR function has the following arguments:

Argument	Description
logical1/2/n	A condition that you want to check if it is TRUE or FALSE

Notes

You can enter up to 255 logical values.

How to apply the XOR function.

Examples

There are two arguments: logical1 = 1>0, logical2 = 2>0. The number of TRUE inputs is even, so the function returns FALSE.

There are two arguments: logical1 = 1>0, logical2 = 2<0. The number of TRUE inputs is odd, so the function returns TRUE.

Return to previous page