Dynamic # of Destination Cells

[TJ]

Is it possible to have a dynamic number of destination cells?

For example



A B C D

1 Principle Interest # of Cycles


2 100 1.03 11


3


4



So that for each interest cycle a new principle is calulated and
output to B7, B8, B9 ... b17 or B7, B8, B9 ...B22 if 16 were the value
for C2. And if that is possible can you make a chart using dynamic
cell ranges?

Thanks

TJ








TJ



Life often turns on such small things as a flickering oil lamp.

- Scheherezade -

 

[Dave Peterson]

Maybe you can modify your formulas:

=IF($C$2-ROW()+ROW($B$7)<=0,"","yourformulahere")

But be aware that charting blank cells looks weird.

maybe you could use:
=IF($C$2-ROW()+ROW($B$7)<=0,na(),"yourformulahere")

Then use format|conditional formatting to hide the n/a's.

 

[TJ]

Maybe you can modify your formulas:

=IF($C$2-ROW()+ROW($B$7)<=0,"","yourformulahere")

But be aware that charting blank cells looks weird.

maybe you could use:
=IF($C$2-ROW()+ROW($B$7)<=0,na(),"yourformulahere")

Then use format|conditional formatting to hide the n/a's.

Thanks for your response. I'll give it a whirl.




TJ






TJ



Life often turns on such small things as a flickering oil lamp.

- Scheherezade -