Or Operator

๋‘ ์‹์— ๋Œ€ํ•ด ๋…ผ๋ฆฌ OR(๋˜๋Š”)์„ ์ˆ˜ํ–‰ํ•ฉ๋‹ˆ๋‹ค.

๊ตฌ๋ฌธ:


Result = Expression1 Or Expression2

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

Result: OR(๋˜๋Š”) ์—ฐ์‚ฐ์˜ ๊ฒฐ๊ณผ๋ฅผ ํฌํ•จํ•˜๋Š” ์ž„์˜์˜ ์ˆซ์ž ๋ณ€์ˆ˜์ž…๋‹ˆ๋‹ค.

Expression1, Expression2: ๋น„๊ตํ•  ์ž„์˜์˜ ์ˆซ์ž ์‹์ž…๋‹ˆ๋‹ค.

๋‘ ๋ถˆ๋ฆฌ์–ธ ์‹์˜ ๋…ผ๋ฆฌ OR(๋˜๋Š”)์€ ์ตœ์†Œํ•œ ํ•˜๋‚˜ ์ด์ƒ์˜ ๋น„๊ต ์‹์ด True์ผ ๊ฒฝ์šฐ True๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

๋น„ํŠธ ๋‹จ์œ„ ๋น„๊ต๋Š” ๋‘ ์‹ ์ค‘ ์ตœ์†Œํ•œ ํ•˜๋‚˜ ์ด์ƒ์— ํ•ด๋‹น ๋น„ํŠธ๊ฐ€ ์„ค์ •๋œ ๊ฒฝ์šฐ ๊ฒฐ๊ณผ์— ๋น„ํŠธ๋ฅผ ์„ค์ •ํ•ฉ๋‹ˆ๋‹ค.

์˜ˆ:


Sub ExampleOr
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 = vA > vB Or vB > vC ' -1
    vOut = vB > vA Or vB > vC ' -1
    vOut = vA > vB Or vB > vD ' -1
    vOut = (vB > vD Or vB > vA) ' 0
    vOut = vB Or vA ' 10
End Sub

Please support us!