MS Excel - Lesson 16: CHOOSE Function in Excel: Microsoft Excel

Understanding Microsoft Excel requires more than a headline. The overview below breaks down the key facts, changes, and user impact.

Microsoft Excel Overview

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