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.
Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us