Post Reply 
Command CHOOSE inside Spreadsheet
08-26-2015, 04:40 PM
Post: #6
RE: Command CHOOSE inside Spreadsheet
Hello,

We'll put this on the list of potential improvements. I agree it would be a nice thing to have.

Just for clarity, something simple like (in B1) =CHOOSE(1,"Select",B2:B6) work for you in your mind? You couldn't take a direct action on change (like excel where this type of thing seems to be used primarily to do a sort or similar), but it would cascade the choice through other formulas.

Thus =B1*5 would multiply the selected item by 5 in the formula.

TW

Although I work for HP, the views and opinions I post here are my own.
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Command CHOOSE inside Spreadsheet - Tim Wessman - 08-26-2015 04:40 PM



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