In - Operator (Checking for occurrences in a list or interval)

Concerns

This operator checks whether a value also occurs in a list.

Example

Dim V1() As Long, V2 As Boolean

V1(0) := 10

V1(1) := 20

V1(2) := 40

V2 := 40 In V1

V2 := 40 In {10, 20, 40}

Result:

V2 contains the value True (-1)

V2 := List(10, 20, 30) In List(5, 10, 15, 20, 25, 30)

V2 := {10, 20, 30} In {5, 10, 15, 20, 25, 30}

Result:

V2 contains the value True (-1) because all items in the left list appear in the right list

This operator checks whether a value occurs in an interval.

Example

V2 := 15 In <<10, 20>>

V2 contains the value True (-1) because 15 is a member of interval [10, 20]