Not Operator

๋น„ํŠธ ๊ฐ’์„ ๋ฐ˜์ „์‹œ์ผœ ์‹์„ ๋ฌดํšจํ™”ํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ:

Result = Not Expression

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

Result: ๋ฌดํšจํ™” ๊ฒฐ๊ณผ๋ฅผ ํฌํ•จํ•˜๋Š” ์ž„์˜์˜ ์ˆซ์ž ๋ณ€์ˆ˜์ž…๋‹ˆ๋‹ค.

Expression: ๋ฌดํšจํ™”ํ•  ์ž„์˜์˜ ์‹์ž…๋‹ˆ๋‹ค.

๋ถˆ๋ฆฌ์–ธ ์‹์„ ๋ฌดํšจํ™”ํ•˜๋ฉด True ๊ฐ’์ด False๋กœ ๋ณ€๊ฒฝ๋˜๊ณ  False ๊ฐ’์ด True๋กœ ๋ณ€๊ฒฝ๋ฉ๋‹ˆ๋‹ค.

๋น„ํŠธ ๋‹จ์œ„์˜ ๋ฌดํšจํ™”์—์„œ๋Š” ๊ฐ๊ฐ์˜ ๊ฐœ๋ณ„ ๋น„ํŠธ๊ฐ€ ๋ฐ˜์ „๋ฉ๋‹ˆ๋‹ค.

์˜ˆ:

Sub ExampleNot

Dim vA As Variant, vB As Variant, vC As Variant, vD As Variant

Dim vOut As Variant

    vA = 10: vB = 8: vC = 6: vD = Null

    vOut = Not vA REM Returns -11

    vOut = Not(vC > vD) REM Returns -1

    vOut = Not(vB > vA) REM Returns -1

    vOut = Not(vA > vB) REM Returns 0

End Sub