Excel FunctionsExcel CHOOSE Function

Using Excel Choose function


The CHOOSE function returns a value based on its position among the sequence of given values.

The sequence mentioned above means the sequence in which we refer to the values in the CHOOSE function. 

The CHOOSE function is an easy and understandable alternative for a lengthy “nested if” function.



The CHOOSE function’s syntax has the following arguments:

  • index_number Required.

This represents which “value argument” is to be selected.

Index_num must be one of the following

  1. A number between 1 and 254,
  2. Formula
  3. Reference to a cell containing a number between 1 and 254

Note: In case index_num is less than 1 or greater than the number of the last value in the sequence argument, CHOOSE returns the #VALUE! error value.

Further, if  index_num is a fraction, it is automatically converted to the lower number.

Value 1 required, subsequent values are optional

The Excel can take a maximum of 254 values as argument inputs in the CHOOSE function.

1 to 254 value arguments from which CHOOSE selects a value or an action to perform based on index_num.

The arguments can be numbers, cell references, defined names, formulas, functions, or text.

NOTE: The CHOOSE function does not take a range or array as an alternative to the value sequence of arguments, and will return #VALUE error.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.