Reference
No results for 'undefined'
    Powered by Algolia

    CHOOSE

    Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up to 254 values based on the index number. For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.

    Syntax

    =CHOOSE(index_num, value, value, ...)

    Parameters

    1. index_num
      • Type: Integer
      • Description: Specifies which value argument is selected. Index_num must be a number between 1 and 254, or a formula or reference to a cell containing a number between 1 and 254
    2. value [repeatable]
      • Type: Any
      • Description: Arguments from which CHOOSE selects a value or an action to perform based on index_num

    Returns

    • Type: Any
    • Description: Value

    Example

    =CHOOSE(2, "foo", "bar")

    Try It Now

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
    Contents