Spread Formula Reference
XOR
Formula Functions > Functions T to Z > XOR

This function returns logical exclusive OR of specified numbers.

Syntax

XOR(value1,value2,..)

Arguments

For the arguments of this function, provide numeric (0 or 1) or logical values (TRUE or FALSE) up to 255 arguments.

Remarks

This function returns TRUE (or 1) when number of true inputs is odd; otherwise, returns FALSE (or 0) when number of true inputs is even.

Data Types

Accepts logical data (Boolean values of TRUE or FALSE) or numerical values (0 or 1). Returns logical data (Boolean values of TRUE or FALSE).

Examples

XOR(3>0,2<9) gives the result TRUE

Version Available

This function is available in Spread for Windows Forms 11.0 or later.