Help with =CHOOSE() - Printable Version +- HP Forums ( https://www.hpmuseum.org/forum)+-- Forum: HP Calculators (and very old HP Computers) ( /forum-3.html)+--- Forum: HP Prime ( /forum-5.html)+--- Thread: Help with =CHOOSE() ( /thread-6168.html) |

Help with =CHOOSE() - Jean-Michel - 04-28-2016 09:22 PM
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} RE: Help with =CHOOSE() - Tim Wessman - 04-28-2016 09:33 PM
(04-28-2016 09:22 PM)Jean-Michel 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 RE: Help with =CHOOSE() - Tyann - 04-28-2016 09:33 PM
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 RE: Help with =CHOOSE() - Jean-Michel - 04-28-2016 09:44 PM
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} RE: Help with =CHOOSE() - Tim Wessman - 04-28-2016 10:41 PM
(04-28-2016 09:44 PM)Jean-Michel 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. |