Eqv Operator

See Also2T0NGX5              ExampleGU39JM>Low

Used to perform a logical equivalence on two expressions.


result = expr1 Eqv expr2


If either expression is a Null1DDW7C0, result is also a Null.  When neither expression is a Null, result is determined according to the following table:


If expr1         And expr2       The result
is                  is                     is


True              True                True

True              False               False

False             True                False

False             False               True


The Eqv operator performs a bit-wise comparison of identically positioned bits in two numeric expressions71RISN and sets the corresponding bit in result according to the following truth table:


If bit in          And bit in         The result
expr1 is         expr2 is            is


0                   0                       1

0                   1                       0

1                   0                       0

1                   1                       1


See Also

Arithmetic OperatorsSH0K1B

Comparison OperatorsNRJZ1K

Concatenation Operators2MYTW1K

Logical Operators1CQVUTN

Operator Precedence23082A9

Other Operators2HA580P

Eqv Operator Example

The example displays a message that depends on the value of variables A, B, and C, assuming that no variable is a Null.  If A = 10, B = 8, and C = 6, both expressions evaluate True.  As a result, the Eqv expression also evaluates True.  To try this example, paste the code into the Declarations section of a form.  Then press F5 and click the form.


Sub Form_Click ()

   Dim A, B, C, Msg                      ' Declare variables.

   A = 10: B = 8: C = 6                  ' Assign values.

   If A > B Eqv B > C Then               ' Evaluate expressions.

      Msg = "Both expressions are True or both are False."


      Msg = "One expression is True and one is False."

   End If

   MsgBox Msg                            ' Display results.

End Sub