Choose function in Excel, how to use the Choose function and illustrative examples

You are looking for ways to use the CHOOSE function in Excel so you can use the CHOOSE function quickly. So, please refer to the following article for syntax of CHOOSE function, for example using CHOOSE function in Excel.

Choose function in Excel, how to use the Choose function and illustrative examples Picture 1

Below the article describes, syntax and examples of using CHOOSE function in Excel, please follow along and learn.

Description of the Choose function

The Choose function will return a value in the input value values ​​based on the index_num index you specified. You can understand the CHOOSE function to help find a value in a value chain, this function is used quite often when combined with other functions.

The syntax of the Choose function

= CHOOSE (index_num; value1; [value2]; .)

Inside:

1. Index_num is a required argument, this is the index you specify the return value in the argument list.
2. Value1 is a required argument, this is the value or reference to the first value in the value list of the CHOOSE function.
3. Value2 . is an optional argument, these are the next values ​​in the CHOOSE function's value list. Excel supports up to 254 values, values ​​can be numbers, cell references, defined names, formulas, functions, or text.

Note

1. If index_num is 1, CHOOSE will return value1; similarly if index_num is 2 then CHOOSE will return value2 .
2. If index_num index_num is greater than the index of the last value in the argument list, CHOOSE will return the #VALUE! Error value.
3. If index_num is a fraction (decimal), it will be the lowest integer to use.
4. The value1, value2 . arguments of the CHOOSE function can be range references as well as individual values.

Example of the Choose function

Example 1: Using the Choose function returns the value 2.

Choose function in Excel, how to use the Choose function and illustrative examples Picture 2

Example 2: Use the CHOOSE function in combination with the SUM function to sum.

Suppose you have the following data table:

Choose function in Excel, how to use the Choose function and illustrative examples Picture 3

Request:

1. Calculate the total amount sold.

You enter the function

= SUM (CHOOSE (2; D6: D14; E6: E14))

According to the above function, CHOOSE will return data in columns E6: E14, then the SUM function will sum the values ​​in columns E6: E14.

Choose function in Excel, how to use the Choose function and illustrative examples Picture 4

To apply the calculation to the following request, while entering the SUM formula combined with the CHOOSE function, press the F4 key after selecting each Value value in the CHOOSE function. From function

= SUM (CHOOSE (2; D6: D14; E6: E14))

you guys will be functional

= SUM (CHOOSE (2; $ D $ 6: $ D $ 14; $ E $ 6: $ E $ 14))

Choose function in Excel, how to use the Choose function and illustrative examples Picture 5

2. Calculate the total quantity sold.

You only need to copy the function formula when you have fixed the data ranges.

Choose function in Excel, how to use the Choose function and illustrative examples Picture 6

Then correct the index_num index to 1 (the Sales Quantity column) so that CHOOSE returns the range of data in the Sales Quantity column and the SUM function sums the values ​​in this column.

Choose function in Excel, how to use the Choose function and illustrative examples Picture 7

Above TipsMake.vn has shared with you the description, syntax and examples of using CHOOSE function in Excel. In addition to using CHOOSE function in combination with SUM function, you can use CHOOSE function in combination with other functions such as IF, VLOOKUP, WEEKDAY . to be able to process data effectively. Good luck!