AND Operator

αž•αŸ’αžŸαŸ†β€‹αž€αž“αŸ’αžŸαŸ„αž˜β€‹αž–αžΈαžšβ€‹αžαžΆαž˜β€‹αžαž€αŸ’αž€β€‹αžœαž·αž‡αŸ’αž‡αžΆΒ αŸ”

αžœαžΆαž€αŸ’αž™β€‹αžŸαž˜αŸ’αž–αž“αŸ’αž’ αŸ–

Result = Expression1 And Expression2

αž”αŸ‰αžΆαžšαŸ‰αžΆαž˜αŸ‰αŸ‚αžαŸ’αžš αŸ–

αž›αž‘αŸ’αž’αž•αž›β€‹ αŸ– αž’αžαŸαžšβ€‹αž›αŸαžβ€‹αžŽαžΆβ€‹αž˜αž½αž™ αžŠαŸ‚αž›β€‹αž€αžαŸ‹αžαŸ’αžšαžΆβ€‹αž›αž‘αŸ’αž’αž•αž›β€‹αž“αŸƒβ€‹αž”αž“αŸ’αžŸαŸ†Β αŸ”

Expression1, Expression2 αŸ– αž€αž“αŸ’αžŸαŸ„αž˜β€‹β€‹αž˜αž½αž™β€‹αž…αŸ†αž“αž½αž“β€‹ αžŠαŸ‚αž›β€‹αž’αŸ’αž“αž€β€‹αž…αž„αŸ‹β€‹αž•αŸ’αžŸαŸ†Β αŸ”

αž€αž“αŸ’αžŸαŸ„αž˜β€‹αž”αŸŠαžΌαž›αžΈαž“β€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž•αŸ’αžŸαŸ†β€‹αž‡αžΆαž˜αž½αž™ AND αž”αŸ‰αž»αžŽαŸ’αžŽαŸ„αŸ‡β€‹β€‹ αžαŸ’αžšαž‘αž”αŸ‹β€‹αžαž˜αŸ’αž›αŸƒ αž–αž·αžβ€‹ β€‹β€‹αž”αŸ’αžšαžŸαž·αž“β€‹αž”αžΎβ€‹αž€αž“αŸ’αžŸαŸ„αž˜β€‹αž‘αžΆαŸ†αž„β€‹αž–αžΈαžšβ€‹αžœαžΆαž™β€‹αžαž˜αŸ’αž›αŸƒβ€‹αžαžΆβ€‹αž–αž·αžβ€‹ αž–αž·αžβ€‹ αŸ–

αž–αž·αž AND αž–αž·αž αžαŸ’αžšαž‘αž”αŸ‹ αž–αž·αž αžŸαž˜αŸ’αžšαžΆαž”αŸ‹β€‹αž”αž“αŸ’αžŸαŸ†β€‹αž•αŸ’αžŸαŸαž„β€‹αž‘αŸ€αžβ€‹αž‘αžΆαŸ†αž„αž’αžŸαŸ‹ αž›αž‘αŸ’αž’αž•αž›β€‹αž‚αžΊ αž˜αž·αž“β€‹αž–αž·αžΒ αŸ”

αžŸαž‰αŸ’αž‰αžΆβ€‹αž”αŸ’αžšαž˜αžΆαžŽβ€‹αžœαž·αž’αžΈ AND αž€αŸβ€‹αž”αŸ’αžšαžαž·αž”αžαŸ’αžαž·β€‹αž€αžΆαžšβ€‹αž”αŸ’αžšαŸ€αž”αž’αŸ€αž”αž”αŸ’αžšαž˜αžΆαžŽβ€‹αžœαž·αž’αžΈβ€‹ bitwise αž˜αž½αž™β€‹αž“αŸƒβ€‹αž”αŸŠαžΈαžβ€‹αžŠαŸ‚αž›β€‹αž˜αžΆαž“β€‹αž‘αžΈαžαžΆαŸ†αž„β€‹αžŠαžΌαž…β€‹αž‚αŸ’αž“αžΆβ€‹αž”αŸαŸ‡αž”αž·αž‘ αž€αŸ’αž“αž»αž„β€‹αž€αž“αŸ’αžŸαŸ„αž˜β€‹αž›αŸαžβ€‹αž–αžΈαžšΒ αŸ”

αž§αž‘αžΆαž αžšαžŽαŸ αŸ–

Sub ExampleAnd

Dim A As Variant, B As Variant, C As Variant, D As Variant

Dim vVarOut As Variant

    A = 10: B = 8: C = 6: D = Null

    vVarOut = A > B And B > C REM returns -1

    vVarOut = B > A And B > C REM returns 0

    vVarOut = (B > D And B > A) REM returns 0

    vVarOut = (B > D And B > A) REM returns 0

    vVarOut = B And A REM returns 8 due to the bitwise AND combination of both arguments

End Sub