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
 Jean-Michel Member Posts: 60 Joined: Oct 2014
Help with =CHOOSE()
Hello all

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}
04-28-2016, 09:33 PM
Post: #2
 Tim Wessman Senior Member Posts: 2,231 Joined: Dec 2013
RE: Help with =CHOOSE()
(04-28-2016 09:22 PM)Jean-Michel Wrote:  I enter what follows in D6 (or whatever other free cell):
=CHOOSE(D6,"AA",D24)

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.
04-28-2016, 09:33 PM
Post: #3
 Tyann Member Posts: 216 Joined: Oct 2014
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
04-28-2016, 09:44 PM (This post was last modified: 04-28-2016 09:59 PM by Jean-Michel.)
Post: #4
 Jean-Michel Member Posts: 60 Joined: Oct 2014
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}
04-28-2016, 10:41 PM
Post: #5
 Tim Wessman Senior Member Posts: 2,231 Joined: Dec 2013
RE: Help with =CHOOSE()
(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.

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)