Spread Formula Reference
Formula Functions / Functions T to Z / XOR
In This Topic
    XOR
    In This Topic

    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.