AND Operator
Logically combines two expressions.
α‘ααα’αα₯α‘α
Result = Expression1 And Expression2
Parameters:
Result: Any numeric variable that records the result of the combination.
Expression1, Expression2: ααααα‘αααα α αͺαα€α α£αα α‘αααααααα αα α‘α’α αα₯ααααα, α αααααααͺ αααααα α¨ααααα αα.
Boolean expressions combined with AND only return the value True if both expressions evaluate to True:
True AND True returns True; for all other combinations the result is False.
The AND operator also performs a bitwise comparison of identically positioned bits in two numeric expressions.
αααααααα:
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 ' returns -1
vVarOut = B > A And B > C ' returns 0
vVarOut = A > B And B > D ' returns 0
vVarOut = (B > D And B > A) ' returns 0
vVarOut = B And A ' returns 8 due to the bitwise And combination of both arguments
End Sub