|
Category
General-Purpose Functions
Description
Whether a value is in a specific set of values
Syntax
InSet(value, value1, value2, value3, ...)
Parameters
value - the value to look up
value1...valueN - values to compare it to
Return Value
1 (true) if value is one of the set of values, 0 (false) otherwise
Notes
InSet(Symbol, $AAPL, $GOOGL, $MSFT)
is equivalent to:
Symbol = $AAPL or Symbol = $GOOGL or Symbol = $MSFT
Arguments can be numeric or strings. If strings then comparison is case-insensitive.
Example
IsTech: InSet(?Sector, "Technology", "Communication Services")
Returns 1 if the stock's sector matches any value in the set.
|
