S
Shafee
Thank you for responding. It took me some time to find my own post t
see if any
one responded, and when I did I was glad to see your response.
I agree that the real issue is in my description of the problem. So
here are more
details. I have a basic formula that computes say revenue (R) out o
amount of
investment (I) and I want to find out how the function "behaves".
One way to do so, is to start with a certain minimal value for I, an
decides on
a certain step-increment (D), create the series I -> I+D for say 5
times and
show next to this series the 50 values of R.
I can define the range say by Imin (Minimal Investment) D (th
increment) and
by Imax (maximal investment) and wish to construct the two column tabl
of
the values of R for the series Imin, Imin+D, Imin+2d,..... unti
Imin-n*D <= Imax.
I know how to do it semi-manually. I want a formula to be placed in
single cell
where I specify the above parameters and the location of the first
cell row of
the table, and when I recalculate, the iteration will cause th
appearnce of the
complete table.
I am looking therefore for something that behaves opposite to wha
INDIRECT
does with playing with the string that determines the location of th
inputs - I
want something like OUTDIRECT that will have values shown in a variabl
range
of cells.. I hoped that it would be possible to achieve it without
VBA copout..lol
thank you very much
Shafe