Help with =CHOOSE()
|
04-28-2016, 09:22 PM
(This post was last modified: 04-28-2016 09:33 PM by Jean-Michel.)
Post: #1
|
|||
|
|||
Help with =CHOOSE()
Hello all
Could one of you please help me with the CHOOSE function of the Spreadsheet App? I have following values: 10 in D2 20 in D3 30 in D4 I want to get a scroll list "10 20 30" I enter what follows in D6 (or whatever other free cell): =CHOOSE(D6,"AA",D2 : D4) I get "Syntax error" While trying several syntaxes, I did manage to get the scroll list operating as wished just once, but, strangely, it collapsed once I have chosen a value with my finger. I DID read the help menu several times but it seems I am still missing something which might be obvious for you. Many thanks advanced and kind regards. {EDIT: added spaces to avoid : D to be converted into a smiley} |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
Help with =CHOOSE() - Jean-Michel - 04-28-2016 09:22 PM
RE: Help with =CHOOSE() - Tim Wessman - 04-28-2016, 09:33 PM
RE: Help with =CHOOSE() - Tyann - 04-28-2016, 09:33 PM
RE: Help with =CHOOSE() - Jean-Michel - 04-28-2016, 09:44 PM
RE: Help with =CHOOSE() - Tim Wessman - 04-28-2016, 10:41 PM
|
User(s) browsing this thread: 5 Guest(s)