The In function tests if a value matches any candidate value in a subsequent list of candidate values. The function returns True if the value matches any of the subsequent candidate values, False if no values are matched.
Usage
In(value, candidate 1,\[candidates 2+\])
Function arguments:
- value (required): The value to test.
- candidate 1 (required): The candidates to test value against.
- candidates 2+ (optional): The additional candidates to test value against.
At least one candidate value must be supplied to test the input value against.
Example
In("green", "red", "green", "blue")
- Return 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. Return False for all other rows.
In(\[Customers\], "Customer 1", "Customer 2")
- Returns True for rows where Customers match βCustomer 1β or βCustomer 2β. Return 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.
Updated 6 months ago