Creating Pixel-Perfect Reports > Getting Started with the Reports Tool in the Web Application > Building Report > Adding a New Sheet and Working with It > Working with Report Sheet Data > Using Formulas > Function Wizard > Search > Choose
Choose(NumElement,Value, …)
NumElement. Value index in the list.
Value - 1,Value - 1, …, Value - N. List of values.
Selects value in the list of values by index number.
Value index should be a number from 1 to 254; a formula, which result is a number from 1 to 254, or a cell reference containing a number from 1 to 254.
The list of values should contain minimum one value and maximum 254 values. Values can be numbers, cell references, formulas, functions, defined names or text.
Value index in the list should equal to or less than the number of elements in the list of values.
| Formula | Result | Description |
| =Choose(2, "first", "second", "third") | second | Select the second value from the specified one. |
| =Choose(1, A1; B1; C1) | 5 | Select the first value - A1. Cell value is 5. |
See also:
