Buzz
Looking for a quick way to utilize Excel's CHOOSE function? Dive into this article for the syntax, usage examples, and more.
Explore the syntax and usage examples of the CHOOSE function in Excel in the following article. Let's delve into it together.
Description of the Choose function
The CHOOSE function returns a value from the input values based on the specified index_num. Think of CHOOSE as a tool to search for a value within a range of values, often used in combination with other functions.
Syntax of the Choose function
=CHOOSE(index_num;value1;[value2];...)
Where:
- Index_num: This is the mandatory parameter, representing the index you specify to choose the return value from the argument list.
- Value1: This is the mandatory parameter, denoting the value or reference to the first value in the CHOOSE function's value list.
- Value2... These are optional parameters, representing the subsequent values in the CHOOSE function's value list. Excel supports up to 254 values, which can be numbers, cell references, named ranges, formulas, functions, or text.
Note:
- If index_num is 1, CHOOSE returns value1; similarly, if index_num is 2, CHOOSE returns value2...
- If the index_num is less than 1 or greater than the index of the last value in the argument list, CHOOSE returns the #VALUE! error.
- If index_num is a fraction (decimal), it will be rounded down to use the lowest integer.
- The value1, value2... arguments of the CHOOSE function can be range references as well as single values.
Example of the Choose function
Example 1: Using the Choose function to return Value 2.
Example 2: Utilizing the CHOOSE function combined with the SUM function to calculate the total.
Suppose you have the following dataset:
Requirement:
1. Calculate the total amount sold.
Enter the formula
=SUM(CHOOSE(2;D6:D14;E6:E14))
According to the above function, CHOOSE will return data in column E6:E14, then SUM will calculate the total of values in column E6:E14.
To continue the calculation for the following requirement, when entering the SUM function combined with the CHOOSE function, press the F4 key after selecting each Value in the CHOOSE function. From the function:
=SUM(CHOOSE(2;D6:D14;E6:E14))
you'll get:
=SUM(CHOOSE(2;$D$6:$D$14;$E$6:$E$14))
2. Calculate the total quantity sold.
You simply need to copy the formula when you've fixed the data ranges.
Then change the index_num to 1 (representing the Sales Quantity column) so that the CHOOSE function returns the data range in the Sales Quantity column, and the SUM function will calculate the total values in this column.
Above, Mytour has provided you with a description, syntax, and examples of using the CHOOSE function in Excel. In addition to using the CHOOSE function combined with the SUM function, you can also use it with other functions such as IF, VLOOKUP, WEEKDAY... to efficiently process data. Wish you success!
