Step-by-step guide to use the Select function in Excel

The Excel CHOOSE function uses an index number to find and return a specific value from its list of data. The index number indicates the position of the value in the list.

Remark † The information in this article applies to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2019 for Mac, Excel 2016 for Mac, Excel for Mac 2011, and Excel Online.

Contents
  1. SELECT Features overview
  2. CHOOSE Function Syntax and Arguments
  3. An example of using the CHOOSE function in Excel to find data
  4. Enter training data
  5. Enter the SELECT function
  6. Calculate employee bonus
  7. Copy employee bonus formula with fountain pen

SELECT Features overview

Like many Excel functions, CHOOSE is most effective when combined with other formulas or functions to return different results.

An example would be to use CHOOSE to perform calculations with the Excel functions SUM, AVERAGE, or MAX on the same data, depending on the index number selected.

CHOOSE Function Syntax and Arguments

Function syntax refers to the layout of the function and includes the function name, parentheses, and arguments.

The syntax for the CHOOSE function is:

= CHOOSE ( index number Value1 value2 Value254

Index_num (necessary). Determines what value to return by the function. Index_num can be a number from 1 to 254, a formula, or a cell reference containing a number from 1 to 254.

Meaning (requires value 1. Additional values ​​up to a maximum of 254 are optional): A list of values ​​returned by the function, depending on the Index_num argument. Values ​​can be numbers, cell references, named ranges, formulas, functions, or text.

An example of using the CHOOSE function in Excel to find data

Follow the example in this guide to illustrate how to use the CHOOSE function. In our example, we use the SELECT function to calculate the annual employee bonus.

The bonus is a percentage of their annual salary and this percentage is based on a performance score of 1 to 4.

The CHOOSE function converts the performance rating to the appropriate percentage:

 Рейтинг 1: 3% 
Рейтинг 2: 5%
Рейтинг 3: 7%
Рейтинг 4: 10%

This percentage is then multiplied by the annual salary to find the employee’s annual bonus.

The example shows how to enter the CHOOSE function in cell G2, and then use the fill handle to copy the function to cells G2-G5.

Enter training data

Enter the following information in cells D1 to G1:

  • Cell D1: Employee

  • Cell D2: J. Smith

  • Cell D3: C. Jones

  • Cell D4: R. Johnston

  • Cell D5: L. Rogers

  • Cell E1: Assessment

  • Cell E2: 3

  • Cell E3: 4

  • Cell E4: 3

  • Cell E5: 2

  • Cell F1: Salary

  • Cell F2: $50,000

  • Cell F3: $65,000

  • Cell F4: $70,000

  • Cell F5: $45,000

  • Cell G1: Bonus

Enter the SELECT function

This section of the tutorial introduces the CHOOSE function in cell G2 and calculates the bonus percentage based on the performance rating for the first employee. These steps apply to Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel for Mac.

  1. Select cell G2 † Displays the results of the function.

  2. Select tab formulas

  3. Select Search and help to open the drop-down list of functions.

  4. Select CHOOSE in the list to open the Function Arguments dialog box.

  5. Place the cursor on the line Index_num in the dialog box.

  6. Select cell E2 on the sheet to enter a cell reference in the dialog box.

  7. Place the cursor on the line Value1 in the dialog box.

  8. Enter 3% in this line.

  9. Place the cursor on the line value2 in the dialog box.

  10. Enter five% in this line.

  11. Place the cursor on the line Value3 in the dialog box.

  12. Enter 7% in this line.

  13. Place the cursor on the line Value4 in the dialog box.

  14. Enter 10% in this line.

  15. Click Okay to end the function and close the dialog box.

The value 0.07 appears in cell G2, the decimal form for 7%.

Excel Online does not have a Formula tab. Instead, use the Insert Function button to enter the SELECT function in Excel Online or another version of Excel.

  1. Select cell G2 † Displays the results of the function.

  2. Select Insert function next to the formula bar.

  3. Select Search and help in the category list.

  4. Select CHOOSE in the list and select Okay

  5. Enter (E2.3%, 5%, 7%, 10%) after = CHOOSE in the formula bar. Don’t forget to put parentheses.

  6. Click Enter

The value 0.07 appears in cell G2, the decimal form for 7%.

Calculate employee bonus

You can now modify the SELECT function in cell G2 by multiplying the function’s results by the employee’s annual salary to calculate their annual bonus.

This change is done using the F2 key to edit the formula.

  1. Select cell G2 to make it active.

  2. Click F2 to put Excel in edit mode. Full function
    =SELECT(E2.3%, 5%, 7%, 10%) appears in a cell with an insertion point after the closing parenthesis of the function.

  3. Enter an asterisk (), the multiplication symbol in Excel, after the closing parenthesis.

  4. Select cell F2 on the worksheet to enter the cell reference to the employee’s annual salary in the cell.

  5. Click Enter to end the formula and exit edit mode.

  6. Cell G2 contains $3,500.00, which is 7% of the employee’s annual salary of $50,000.00.

  7. Select cell G2. † The full formula = CHOOSE(E2.3%, 5%, 7%, 10%) * F2 is displayed in the formula bar above the worksheet.

Copy employee bonus formula with fountain pen

The last step is to copy the formula in cell G2 to cells G3-G5 using the fill handle.

  1. Select cell G2 to make it active.

  2. Place your mouse pointer over the black square in the lower right corner of cell G2. The pointer changes to a plus sign (+).

  3. Drag the fill handle to a cell G5.

  4. Cells G3-G5 contain bonus numbers for the other employees.

Leave a Reply

Your email address will not be published.