Spread Formula Reference
Formula Functions / Functions A to C / BITXOR
In This Topic
    BITXOR
    In This Topic

    This function returns bitwise XOR of the two specified numbers.

    Syntax

    BITXOR(value1, value2)

    Arguments

    For the arguments of this function, both values must be in decimal form and greater than or equal to 0.

    Remarks

    In this function, if value of any parameter's bits at same position is not equal only then the value of each bit position is counted.

    Data Types

    Accepts decimal form of data. Returns decimal form of data.

    Examples

    BITXOR(6,2) gives the result 4.

    BITXOR(8,3) gives the result 11.

    Version Available

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