MS Excel - Lesson 16: CHOOSE function in Excel

Choose in Excel allows you to select a value from a list of more than 29 items

The Choose function uses index-num to return a value from the list of arguments

For example, if the value from 1 to 7 is the corresponding value of the day of the week. When a number between 1 and 7 uses index-num, CHOOSE () returns the value of one of those dates

Structure of CHOOSE () function

CHOOSE (Index-num, Value 1, value 2, value 3, .)

Index_num

The index-num function sets the return values. Return values ​​are a number between 1 and 29, or a formula or reference in a cell that contains a number from 1 to 29

- If index-num is 1, Choose function returns value 1, if two functions return value 2, .

- If index-num is less than 1 or greater than the last value in the list, the Choose function returns the error value of #VALUE!

- If index-num is a fraction, it will remove the lowest integer part before giving the result

Value1, Value2, Value3 .

A set of values ​​from the returned result

The example uses the CHOOSE function in Excel

- Click on the cell where you want to return the function result

- From the Insert menu, click Function . , Insert Function dialog box is displayed

- From the Insert Function dialog box, click the arrow pointing down from the Or select a category section , select the Lookup & Reference option .

- In the Select a function section , select CHOOSE and click OK . Display the CHOOSE dialog box

- Enter a cell reference or a value into Index_num. In the case above example, enter 3

- Press Tab and enter the first value in Value1 . Enter 'Monday'

- Press Tab and enter the second value in Value2 . Enter 'Tuesday'

- Repeat the above steps until the end (as the example above is from Monday to Sunday).

- Click OK when done. You will see results displayed on the 4th day

Note : If we enter the Index_num item 5, the result is returned to 6th