IN Function
The IN function evaluates the position of one string value (value 2) within another string value (value 1).
Syntax
IN(value 1,value 2)
Example 1
IN("Toronto, Ontario","Ontario")
Returns a value of 10 as the O in Ontario is the 10th character of the string.
Example 2
IN("Toronto, Ontario","Alberta")
Returns a value of 0 as Alberta does not appear in the string at all.