The following warnings occurred:
Warning [2] count(): Parameter must be an array or an object that implements Countable - Line: 795 - File: showthread.php PHP 7.4.33 (FreeBSD)
File Line Function
/showthread.php 795 errorHandler->error





Post Reply 
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}
Find all posts by this user
Quote this message in a reply
Post Reply 


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)