Microsoft Office Tutorials and References
In Depth Information
Choosing the Right Value
what to see.
Cells C4:C15 contain formulas with the CHOOSE function. The formula in cell
=CHOOSE(B4,”January”, “February”, “March”, “April”,
“May”, “June”, “July”, “August”, “September”,
“October”, “November”, “December”)
Cell B4 contains the value 1, so the first argument starting in the list of
possible returned strings (that is, “January”) is returned.
CHOOSE is most often used to return meaningful text that relates to a number,
such as returning the name of a month from its numeric value. But CHOOSE is
not restricted to returning text strings. You can use it to return numbers.
Try it yourself! Here’s how:
1. Enter a list of numeric values into a worksheet column.
These values should all be small, such as 1, 2, 3, and so on.
2. Click the cell to the right of the first value.
3. Enter =CHOOSE( to start the function.
4. Click the cell to the left (the one that has the first value).
Or you can enter its address.
5. Enter a comma ( ,).
6.Enteralistoftextstringsthateachhaveanassociationwiththenumbers entered in Step 1.
Each text string should be in double quotes and separated with commas
(for example, “January”,“February”,“March” ).