XOR Operator

Performs a logical Exclusive-Or combination of two expressions.

Syntax:

Result = Expression1 XOR Expression2

Parameters:

Result: Any numeric variable that contains the result of the combination. Expression1, Expression2: Any numeric expressions that you want to combine. A logical Exclusive-Or conjunction of two Boolean expressions returns the value True only if both expressions are different from each other. A bitwise Exclusive-Or conjunction returns a bit if the corresponding bit is set in only one of the two expressions.

Example:

Sub ExampleXOR Dim vA As Variant, vB As Variant, vC As Variant, vD As Variant Dim vOut As Variant vA = 10: vB = 8: vC = 6: vD = Null vOut = vA > vB XOR vB > vC ' returns 0 vOut = vB > vA XOR vB > vC ' returns -1 vOut = vA > vB XOR vB > vD ' returns -1 vOut = (vB > vD XOR vB > vA) ' returns 0 vOut = vB XOR vA ' returns 2 End Sub