Table of contents
TOC
Collapse the table of content
Expand the table of content

And Operator

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Used to perform a logical conjunction on two expressions. Syntaxresult=expression1Andexpression2 The And operator syntax has these parts:

PartDescription
resultRequired; any numeric variable.
expression1Required; any expression.
expression2Required; any expression.

Remarks If both expressions evaluate to True, result is True. If either expression evaluates to False, result is False. The following table illustrates how result is determined:

If expression1 isAnd expression2 isThe result is
TrueTrueTrue
TrueFalseFalse
TrueNullNull
FalseTrueFalse
FalseFalseFalse
FalseNullFalse
NullTrueNull
NullFalseFalse
NullNullNull

The And operator also performs a bitwise comparison of identically positioned bits in two numeric expressions and sets the corresponding bit in result according to the following table:

If bit in expression1 isAnd bit in expression2 isThe result is
000
010
100
111

Example

This example uses the And operator to perform a logical conjunction on two expressions.

Dim A, B, C, D, MyCheck
A = 10: B = 8: C = 6: D = Null    ' Initialize variables.
MyCheck = A > B And B > C    ' Returns True.
MyCheck = B > A And B > C    ' Returns False.
MyCheck = A > B And B > D    ' Returns Null.
MyCheck = A And B    ' Returns 8 (bitwise comparison).
© 2018 Microsoft