Function Index

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>,…)

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.

Examples

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.