Exclusive Or [XOr]

Return to Complete List of Functions

The Exclusive Or function determines if one and only one of two conditions is true. Parameters ------------------ Condition 1       The first value to use in the condition. Condition 2       The second value to use in the condition. Both values can be any combination of raw data, calculated values, or constants. Function Value ------------------------ This function determines if one and only one of two conditions is true. A condition is considered to be true if it has a non-zero value. Therefore, If value 1 is not zero and value 2 is zero, or visa-versa, it returns 1; otherwise, it returns 0. If either value is null, a null is returned. Value 1   Value 2    XOr(Value 1,Value 2) -----------------------------------------------------------------     0             0                        0     0             1                        1     1             2                        0    -2             0                        1