LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
web based equations shane Excel Discussion (Misc queries) 3 October 25th 07 01:51 PM
Selection of Cells based on a criteria Scott Excel Discussion (Misc queries) 2 July 27th 07 04:47 PM
Random Selection based on Difficulty [email protected] Excel Discussion (Misc queries) 4 May 13th 07 03:31 AM
import worksheet based on a selection John Casteel Excel Discussion (Misc queries) 0 June 15th 06 06:48 AM
limit cell list selection based on the selection of another list lorraine Excel Worksheet Functions 2 December 14th 04 08:17 PM


All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"