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.
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.
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.
More About Logical Functions
Logical functions test for True/False values. They evaluate a condition, and return a value based on whether the condition is True or False.