In
Test if a value matches any value in a subsequent list of values. Returns True if the first value matches any of the subsequent values. Returns False if no values are matched.
Usage
In(value, candidate 1,[candidates 2+])
value (required) The value to test.
candidate 1 (required) The candidates to test value against. You must supply at least one candidate.
candidates 2+ (optional) You can supply additional candidates to test against.
Example
In("green", "red", "green", "blue")
- Returns True.
In("yellow", "red", "green", "blue")
- Returns False.
In([Customer ID], 2000, 3000, 4000)
- Returns True for rows where Customer ID is 2000, 3000, or 4000. Returns False for all other rows.
In([Customers], "Customer 1", "Customer 2")
- Returns True for rows where [Customers] matches “Customer 1” or “Customer 2”. Returns false for all other rows.
In("John Smith", [Customers], [Buyers])
- Returns True for rows where “John Smith” appears in either the Customers or the Buyers columns.