{"id":698,"date":"2019-04-18T15:00:43","date_gmt":"2019-04-18T12:00:43","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=698"},"modified":"2019-04-18T17:10:08","modified_gmt":"2019-04-18T14:10:08","slug":"the-choose-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-choose-function\/","title":{"rendered":"The CHOOSE Function"},"content":{"rendered":"\n

The CHOOSE<\/b> function returns a value from an array of values, that corresponds to a specific position in that array. <\/p>\n\n\n\n

We have prepared a tutorial on the CHOOSE<\/a><\/strong> function to explain it in a bit more detail.<\/p>\n\n\n\n

\n\nThe syntax of the function is the following:\n\n<\/p>\n\n\n\n

CHOOSE<\/strong>(index<\/strong>, v1<\/strong>, [v2<\/strong>, ..<\/strong>.]) <\/p> index<\/strong> : it is required. It must be between 1 and the number of values (up to 254).
v1, v2<\/b><\/span><\/font>, … : v1 is required. The rest (up to 254) are optional. They are the values from which CHOOSE selects one according to the value of index.
<\/cite><\/blockquote>\n\n\n\n

<\/div>\n\n\n\n\n
<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here is an example of how to use the CHOOSE function:<\/strong><\/p>\n\n\n\n

Calculate in the respected cell of column D the bonus (in euros) for every employee in accordance with his grade of assessment.
\nAssessment 1=0%
\nAssessment 2=5%
\nAssessment 3=10%
\nAssessment 4=13%<\/p>\n\n\n\n

\n