Eqv Operator

See Also2T0NGX5              ExampleGU39JM>Low

Used to perform a logical equivalence on two expressions.

Syntax

result = expr1 Eqv expr2

Remarks

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."

   Else

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

   End If

   MsgBox Msg                            ' Display results.

End Sub