How to Use Excel's Choose Function

Excel's Choose function returns a value from a list of arguments based on the specified index number. For example, this might be used to convert a number between 1 and 7 to the days of the week. The following steps will show how to use Excel's Choose function.

Instructions

Difficulty: Moderate

1. Learn the syntax of Choose. It is Choose (index_num,value_1,value_2,…,value_n) where index_number is a value between 1 and 29. Between 1 and 29 value arguments also must exist.
2. Study additional restrictions on the value of index_num. It will first be truncated to the next lowest integer if it is a fraction. If this value is less than 1 or greater than the number of value arguments, the #Value! error value will be returned.
3. Understand how Choose works. Index_num specifies the value argument that will be selected and may be a formula, number or reference to a cell. If index_num is 1, the first value argument will be returned; if it is 2, the second value argument will be returned and so on.
4. Examine the behavior of Choose when index_num is an array. Every argument value will be evaluated before Choose executes. The value arguments may be literal values, cell or range references, defined names, formulas or functions.
5. Look at some examples of how Choose might be used.
   
   Choose (3, Saturday, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday) returns Monday.
   Choose(2, A1:A10, B1:B10, C1:C10)) returns B1:B10.
   Sum (A1:Choose(2, A2, A3, A4)) returns SUM(A1:A3). Note that Choose returns A3 in this example, which is then used as part of a range reference for Sum.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.