Determines
whether the given value is within a set.
SyntaxOneof(s1, s2 [, s3 ...])
Parameters
Parameter
|
Description
|
s1
|
The position of the value you want to select
within the set. If this value is not a whole number, the function
rounds s1 down to the nearest whole value.
|
s2
|
The first value in the set of values.
|
s3 (Optional)
|
Additional values in the set.
|
ExamplesThe
following expressions are examples that use the Oneof function:
Expression
|
Returns
|
Oneof(3, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1)
|
True (1)
|
Oneof("John", "Bill", "Gary", "Joan", "John", "Lisa")
|
True (1)
|
Oneof(3, 1, 25)
|
False(0)
|
Oneof("loan", Fields[*])
|
Verifies whether any occurrence of Fields has
a value of loan.
|
|
|
|