Inlist

Syntax

Inlist(Value,  Choice1, Choice2, Choice3, ..., ChoiceN)

Description

The Inlist function returns TRUE if Value is equal to one of the n Choices, and FALSE otherwise.

Examples

If( Inlist(Month,  1, 2, 7, 8), 10, 20)  = 10 in January, February, July and August, and 20 in the other months

Inlist( \Demand Sites\South City:Priority,  1, 2, 10) = TRUE if the priority for South City is 1, 2 or 10