IN( )
Tests if a value is equal to a value in a list.
Syntax
IN(value, check1,…, checkN)
Arguments
value
The value to test. The value can be a string, numeric, or date value.
check1, …, checkN
The value or values to compare to.
Returns
True if value is equal to one of the check values; returns false otherwise.
Example
The following example tests if New Haven, Baltimore, or Cooperstown are values in the city data field. If any one of the cities is in the data field, IN( ) returns true.
IN([city], "New Haven", "Baltimore", "Cooperstown")
The following example tests if 9/15/08 or 9/30/08 are values in the payDate data field. If you supply a literal date as an argument, you must include the time value, as shown in the following example:
IN([payDate], "9/15/08 12:00 AM", "9/30/08 12:00 AM")
The following example uses IN( ) in conjunction with the IF( ) function to test if Ships or Trains are values in the ProductLine data field. If Ships or Trains is a value in the field, the computed column displays Discontinued Item; otherwise, the product line value is displayed as it appears in the field.
IF(IN([ProductLine], "Ships", "Trains"),"Discontinued Item", [ProductLine])