You can use Index_num to return a value in the list of numeric arguments.
Use the CHOOSE function to return any of up to 29 pending values based on index number based on the index number. For example, if the value
1 to 7 represents the seven days of a week, and when a number between 1 and 7 is used as Index_num, the CHOOSE function returns one of those days.
grammar
CHOOSE(Index_num,value1,value2,…)
Index_num Indicates the parameter value of the parameter number to be selected.
Index_num must be a number between 1 and 29, or a formula or cell reference containing the numbers 1 to 29.
- If Index_num is 1, the CHOOSE function returns value1; If it is 2, the CHOOSE function returns value2, and so on.
If Index_num is less than 1 or greater than the sequence number of the last VALUE in the list, CHOOSE returns the #VALUE! Error value. .
- If Index_num is a decimal, it is rounded before use.
Value1,value2,… From 1 to 29 numeric arguments, the function CHOOSE selects a numeric value or performs an operation based on Index_num.
Parameters can be numbers, cell references, defined names, formulas, functions, or text.
Instructions
- If Index_num is an array, every value is evaluated when the CHOOSE function evaluates it.
The numerical arguments of the CHOOSE function can be not only individual values, but also regional references.
For example, the following formula:
=SUM(CHOOSE(2,A1:A10,B1:B10,C1:C10))
Equivalent to:
=SUM(B1:B10)
The value is then returned based on the value in the area B1:B10.
The CHOOSE function is evaluated first, returning references B1:B10. The function SUM is then summed with B1:B10.
That is, the result of the function CHOOSE is an argument to the function SUM.
I want to create a clean, concise and efficient office reference manual, in order to maintain a good reference experience, I did not add any third-party advertisements in my blog, of course, if you are willing, you can watch the following video, it can bring me some income, so that I can better maintain the server to provide higher quality service, thank you for your help and support.
You can choose any link below to watch my videos and I will earn some money to strengthen the site and resist DDOS attacks that may happen at any time, thank you for your support!
(Please note: Please do not maliciously click on links or video ads to increase invalid traffic, as this can result in lower or no revenue.)
Learn to consult the manual video
(Will be released in the later period with the consult the manual article, please pay attention.)
My Febspot video list (Learn after-school relaxation videos)
https://suu.us/sponsor
My Febspot video home page
https://www.febspot.com/leet4477/