This function, when calculated, returns the value, that is specified by the index number.
Choose([Index Number], [Value1], [Value2], [Value n])
Where:
Index Number is a number, or a reference to a number, that specifies which value argument to select.
Value1, Value2, Value n are the value arguments, that you want to choose between.
There can be 1 to 254 Value arguments in any one Choose function.
Rule | Meaning |
|---|---|
| Choose(CustomerNumberComboBoxReturn, "John Smith", "Sandra Thompson", "Tom Harrison") | The Choose function uses the return value from the CustomerNumberComboBox, to return the corresponding value argument, which in this example is a customer's name. |
CustomerNumberComboBoxReturn Value | Value1 | Value2 | Value3 | Result of the Choose function |
|---|---|---|---|---|
| 2 | "John Smith" | "Sandra Thompson" | "Tom Harrison" | Sandra Thompson |
| 1 | "John Smith" | "Sandra Thompson" | "Tom Harrison" | John Smith |