Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud
Try in the cloud

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.

XOR Function: FALSE

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

XOR Function: TRUE

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action