complicated change to formula (conintuous)
An example of the data and any formulae you are using might enlighten us.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"theredspecial" wrote in message
...
i've build a model in excel.
on the basis of a few variables i made quite a number of sheets. one
variable i had to keep constant, otherwise i would need 3d tables. now
that
the model is almost done, this one variable needs to change.
it needs to take discrete values between 0 and 5 (for example, and in
steps
of .25) the change of this value has to be calculated in the model and the
result needs to be in a table. every result (which will be 4*6*something)
need to be visible, as they will be used in a graph.
(am i still clear?)
now, how do I change that one value and allow excel to draw the graph?
(if you need more information, ask your question and i will try to answer
them)
|