deepcalc
DocsCHOOSE

CHOOSE

View as markdown/docs/functions/choose.md Ask Claude about this pageOpens Claude with this page's address

Chooses a value from a list by index.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Any value

Examples

=CHOOSE(2, "red", "green", "blue")
Result green

Syntax

CHOOSE(index_num, value…)
index_num
number required
value…
any required
ABSReturns absolute value of a number. ACOSReturns arccosine of a number. ACOSHReturns inverse hyperbolic cosine. ACOTReturns the arccotangent of a number. ACOTHReturns the inverse hyperbolic cotangent. ADDAdds two numbers: sheets exposes the + operator as a function.