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

Please support us!