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. |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
Command CHOOSE inside Spreadsheet - Elton Freitas - 08-25-2015, 01:42 PM
RE: Command CHOOSE inside Spreadsheet - Tim Wessman - 08-25-2015, 02:00 PM
RE: Command CHOOSE inside Spreadsheet - Elton Freitas - 08-25-2015, 02:28 PM
RE: Command CHOOSE inside Spreadsheet - cyrille de brébisson - 08-26-2015, 05:47 AM
RE: Command CHOOSE inside Spreadsheet - Elton Freitas - 08-26-2015, 11:34 AM
RE: Command CHOOSE inside Spreadsheet - Tim Wessman - 08-26-2015 04:40 PM
RE: Command CHOOSE inside Spreadsheet - Elton Freitas - 08-26-2015, 07:10 PM
|
User(s) browsing this thread: 1 Guest(s)