 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2005Multiple functions per cell?
Hey. Is it possible to have more than one function assigned to a single cell? I would like to have formulas on 2 different worksheets, both of which will produce different results (only one will finally effect the critical cell), with the possibility of the results from these different worksheets to show in the critical cell. One of the results comes from a 'vlookup' function, the other result is a simple A*B=C type function. I want the user to have the option of choosing how they get their result. Make sense?? You can use the CHOOSE() function to allow the user to select from many possible calculations. For example, in cell A1 allow the user to enter an integer: 1,2,3 In cell B1 insert: =CHOOSE(A1,C1,D1,E1) If the user enter 1 in A1, then B1 will display the C1 calculation. If the user enter 2 in A1, then B1 will display the D1 calculation. If the user enter 3 in A1, then B1 will display the E1 calculation. Put your own cells in place for C1, D1, E1 in the above example.  SignatureGary''s Student > Hey. > Is it possible to have more than one function assigned to a single cell? [quoted text clipped - 6 lines] > how they get their result. > Make sense?? Thanks Gary's Student :) > You can use the CHOOSE() function to allow the user to select from many > possible calculations. For example, in cell A1 allow the user to enter an [quoted text clipped - 19 lines] > > how they get their result. > > Make sense?? Your Welcome SignatureGary''s Student > Thanks Gary's Student :) > [quoted text clipped - 21 lines] > > > how they get their result. > > > Make sense?? Hi again. Does that allow for selections made from drop down lists? In order to produce the correct answer, the user selects from 2 adjacent drop down lists. The options that appear in the 2nd drop down list need to depend on what selection is made from the first drop down list. The final result is then dependant on the selection made from that drop down list. Make sense? How do I do that??? > You can use the CHOOSE() function to allow the user to select from many > possible calculations. For example, in cell A1 allow the user to enter an [quoted text clipped - 19 lines] > > how they get their result. > > Make sense?? Yes. It makes sense. In my example A1 held the user selection. In your application, arrange the drop downs to deposition the final result in your user-selection-cell. CHOOSE() doesn't care how the cell gets filled, only that it is a simple sequence of digits. SignatureGary''s Student > Hi again. > Does that allow for selections made from drop down lists? [quoted text clipped - 29 lines] > > > how they get their result. > > > Make sense?? Thanks again mate. > Yes. It makes sense. In my example A1 held the user selection. In your > application, arrange the drop downs to deposition the final result in your [quoted text clipped - 34 lines] > > > > how they get their result. > > > > Make sense?? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.