Returns the value with the corresponding index position. When an index number is provided and a corresponding value does not exist, a Null result is returned.
Choose(<index Number>,<value 1>, <value 2>…)
index number (required) The index number of the value returned. Index value needs to be a number, a formula or column that references a number.
value 1 (required) The values from which to choose. At least one value must be provided.
value 2+ (optional) Additional values are optional.
Choose(1, “value 1”, “value 2”, “value 3”)
- Returns value 1.
Choose(Weekday([Date]), “Sunday”, “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, “Saturday”)
- Returns the name of the day of the week falling on the date in the [Date] column.
More About Logical Functions
Logical functions test for True/False values. They evaluate a condition, and return a value based on whether the condition is True or False.