Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello;
I would very much appreciate your help. 1) I've developed 12 different (independent) equations y=fn(x), each equation depends on the value of x::cell H30 2) Each equation is given a short descriptive/relevant name for easy selection from a list. For example: mon1 singular:: y = fn1(x) mon2 discontinuity:: y = fun2(x) ............................. mon12 infinite:: y = fun12(x) 3) I used Data Validation in cell H5 to select from the list: mon1 singular, mon2 discontinuity, ..., etc. 4) Now, depending on the selection in H5 from the pull-down list, I need to link the descriptive name to the relevant equation and return its value y to cell H38. 5) A nested IF in H38 would be horrible, very long, and most likely wouldn't work since it would involve more than the allowable max number of loops in a w/s nested IF. 6) On the other hand, having 12 FUNCTION() each representing an equation, the use of w/s CHOOSE() function requires a numerical index!! Is there an elegant way of doing that ?? Thank you kindly. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
web based equations | Excel Discussion (Misc queries) | |||
Selection of Cells based on a criteria | Excel Discussion (Misc queries) | |||
Random Selection based on Difficulty | Excel Discussion (Misc queries) | |||
import worksheet based on a selection | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |