# Function "Choose" (index;LIST of values)

I have an age related variable: costs vary by three age groups - €1361 (0-13yrs); €680 (14-20yrs); €272 (21+yrs). Can I use the function "choose"? Does anyone how to use this function? I have read the function help, but could not figure out how to add "index":-(

Your help would be greatly appreciated!

Bing

## Comments

Andrew MunzerI will highlight how the Choose function using the example below.

Choose( index; 100; 200; 300)

We will assume there is some formula that provides the value for "index". This formula must provide back a value of 1, 2 or 3, or the Choose function will fail.

I don't think the Choose function on its own will be the best approach for your issue.

However, a table will work nicely.

Table name: AgeCost

Table lookup method: Truncate

Table data:

Your expression would then be AgeCost[age], which I would place in a formula variable.

With the lookup method of truncate, the expression will return...

I hope this is helfpul.

Andrew

Bing WangDear Andrew,Thanks so much for your help! As you suggested, the function with a table works very well! Thanks again. Sorry, I was busy preparing documents for a meeting and didn't have a chance to reply. My apologies.BingAndrew MunzerI am glad this worked for you.

Andrew

Please sign in to leave a comment.