View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
monir monir is offline
external usenet poster
 
Posts: 215
Default Evaluating Equations Based on Selection !!

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.