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

Please support us!