In
Returns true if the value is equal to any of the values in the list.
Variants
In(expression, value1, value2, …, valueN)
Returns true if the expression is equal to one of the values.
Parameters
- expression
- The column, expression, or literal value to test. Can be of any type.
- value
- The value to compare with the expression. All values should be of the same type as the expression. Can be a column, expression, or literal value.
Returns
Boolean
Examples
In([State], "CA", "IL")This formula will return true if the value "CA" or "IL" is specified in the "State" column.
In(single-reference-column, multi-reference-column)
Returns true if the value of the single-reference-column is listed among the values in the multi-reference-column.
Parameters
- single-reference-column
- The single reference column to test.
- multi-reference-column
- The multi-reference column that contains the values to search for the single-reference-column value. The multi-reference-column should refer to the same table as the single-reference column.
Returns
Boolean
Examples
In([Best Supplier], [Possible Suppliers])This formula will return true if the value in the "Best Supplier" column is listed among the values in the "Possible Suppliers" column.