Function "Choose" (index;LIST of values)

• Official comment

  

  Andrew Munzer

  April 04, 2018 13:43 (Edited April 04, 2018 13:43)

  I 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.

  • index 1 - Choose returns 100
  • index 2 - Choose returns 200
  • index 3 - Choose returns 300

  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:

  • Index, Value 
  • 0, 1361
  • 14, 680
  • 21, 272

  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...

  • 1361 for ages 0-13
  • 680 for ages 14-20
  • 272 for ages 21 and above

  I hope this is helfpul.

  Andrew

  Comment actions Permalink
• 

  Bing Wang

  April 11, 2018 01:28

   

  Dear 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.

  Bing

  0

  Comment actions Permalink
• 

  Andrew Munzer

  April 11, 2018 12:02

  I am glad this worked for you.

  Andrew

  0

  Comment actions Permalink

Please sign in to leave a comment.