Function CONTAIN

Returns TRUE if the list contains the specified value, FALSE otherwise

Usage

CONTAIN(list, value)

list	(Required) The list to search into
value	(Required) The value to search for

Example	With these variables	Result
CONTAIN([“CAD”, “USD”], “USD”)	(None)	TRUE
CONTAIN(currencies, “EUR”)	currencies is ["CAD", "USD"]	FALSE

The [ and ] mark the beginning and end of a list.

To do the equivalent within a text (instead of within a list), see the FIND and SEARCH functions.