AND Operator

๋‘ ์‹์„ ๋…ผ๋ฆฌ์ ์œผ๋กœ ๊ฒฐํ•ฉํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ:

Result = Expression1 And Expression2

๋งค๊ฐœ ๋ณ€์ˆ˜:

Result: ๊ฒฐํ•ฉ ๊ฒฐ๊ณผ๋ฅผ ๊ธฐ๋กํ•˜๋Š” ์ž„์˜์˜ ์ˆซ์ž ๋ณ€์ˆ˜์ž…๋‹ˆ๋‹ค.

Expression1, Expression2: ๊ฒฐํ•ฉํ•  ์ž„์˜์˜ ์‹์ž…๋‹ˆ๋‹ค.

AND๋กœ ๊ฒฐํ•ฉ๋œ ๋ถˆ๋ฆฌ์–ธ ์‹์€ ๋‘ ์‹์ด ๋ชจ๋‘ True๋กœ ํ‰๊ฐ€๋  ๊ฒฝ์šฐ์—๋งŒ True ๊ฐ’์„ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

True AND True๋งŒ True๋ฅผ ๊ตฌํ•˜๋ฉฐ ๋‹ค๋ฅธ ๋ชจ๋“  ๊ฒฐํ•ฉ์€ False๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๋˜ํ•œ AND ์—ฐ์‚ฐ์ž๋Š” ๋‘ ๊ฐœ์˜ ์ˆซ์ž ์‹์—์„œ ๋™์ผํ•œ ์œ„์น˜์— ์žˆ๋Š” ๋น„ํŠธ์˜ ๋น„ํŠธ ๋‹จ์œ„ ๋น„๊ต๋ฅผ ์ˆ˜ํ–‰ํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ:

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 = A > B And B > D 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