Help with =CHOOSE()

04282016, 09:22 PM
(This post was last modified: 04282016 09:33 PM by JeanMichel.)
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} 

04282016, 09:33 PM
Post: #2




RE: Help with =CHOOSE()
(04282016 09:22 PM)JeanMichel Wrote: I enter what follows in D6 (or whatever other free cell): Is your formula in D6? If so, wouldn't that mean you are going to store into D6 and overwrite your formula upon picking your choose? Put a different variable/location for the target first argument. A (home variable), C3, etc TW Although I work for the HP calculator group, the views and opinions I post here are my own. 

04282016, 09:33 PM
Post: #3




RE: Help with =CHOOSE()
Bonjour
La syntaxe est cel1=CHOOSE(cell2,"titre",choix) cel1 contient la liste de choix cel2 contient le n° d'option choisie cel1 doit être différent de cel2. Donc Hello The syntax is cel1 = CHOOSE ( cell2 , "title" , choice) cel1 contains the list of choices CEL2 contains the number of the option chosen cel1 must be different from CEL2 . So D6=CHOOSE(D5,"AA",D24) Vous pouvez aussi écrire : You can also write : D6=CHOOSE(D5,"AA",{10,20,30}) d'après ce que jai essayé from what I tried Sorry for my english 

04282016, 09:44 PM
(This post was last modified: 04282016 09:59 PM by JeanMichel.)
Post: #4




RE: Help with =CHOOSE()
Thanks Tim And Tyann for your prompt reply, but unfortunately I still cannot have it functioning.
I tried again by having the CHOOSE function pointing to another cell (as first argument) than the one where it is, but no way. Same with replacing the cells references by a list {10 20 30}. Might this be RPN sensible? EDIT: switching to BOOK entry mode makes it work flawlessly. So, following question: is it possible to have it functioning in RPN mode? {2nd EDIT: it seems that one has to be in BOOK mode at the times you enter the equation. Switching back to RPN has no detrimental effect once the equation is entered} 

04282016, 10:41 PM
Post: #5




RE: Help with =CHOOSE()
(04282016 09:44 PM)JeanMichel Wrote: Might this be RPN sensible? It works fine here for me in RPN. Are you remembering to put ' ' around your formula? To use the spreadsheet in RPN mode, formulas are created using the algebraic ' ' objects. 'CHOOSE(A1,"choice",D13)' is equivalent to =CHOOSE1(A1,"choice",D13) in textbook/algebraic. TW Although I work for the HP calculator group, the views and opinions I post here are my own. 

« Next Oldest  Next Newest »

User(s) browsing this thread: 1 Guest(s)