A
amir.companieh
Hi all
I have a sheet that performs a series of calculations based on a
single value and culminating in another single value. Also the series
of calculations is too complicated and long and numerous to do in a
single calculation. What I have is, in another sheet, I have a range
of that single initial value, from -90% to +90% of the initial value,
and I'd like to somehow calculate that value resulting from all the
various initial values and insert them in the first sheet...how can i
do that?
for example: sheet A contains the range of initial values and the
result of the calculations performed in sheet B
Percentage Initial Value Result
-90% 10
-80% 20
.... ....
0% 100 300
10% 110
20% 120
.... ...
90% 190
sheet B: a series of calculations based on the initial value. Ex:
initial value is set to 100 and results after a long series of
calculations is 300...
Now i'd like to assign something to the -90% row of the Result column
in sheet A such that it would (in the background?) insert 10 into the
initial value of sheet B, do the calculations, and return that final
value to that locations...any ideas?
I have a sheet that performs a series of calculations based on a
single value and culminating in another single value. Also the series
of calculations is too complicated and long and numerous to do in a
single calculation. What I have is, in another sheet, I have a range
of that single initial value, from -90% to +90% of the initial value,
and I'd like to somehow calculate that value resulting from all the
various initial values and insert them in the first sheet...how can i
do that?
for example: sheet A contains the range of initial values and the
result of the calculations performed in sheet B
Percentage Initial Value Result
-90% 10
-80% 20
.... ....
0% 100 300
10% 110
20% 120
.... ...
90% 190
sheet B: a series of calculations based on the initial value. Ex:
initial value is set to 100 and results after a long series of
calculations is 300...
Now i'd like to assign something to the -90% row of the Result column
in sheet A such that it would (in the background?) insert 10 into the
initial value of sheet B, do the calculations, and return that final
value to that locations...any ideas?