NotIn - Operator (Checking for nonoccurrence 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 := 30 NotIn V1

Result:

V2 contains the value True (-1)

V2 := List(3, 6, 10) NotIn List(5, 10, 15, 20, 25, 30)

Result:

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

This operator checks whether a value is not occurring in an interval.

Example

V2 := 30 NotIn <<10, 20>>

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