Dynamic # of Destination Cells

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 -

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 wrote:
>
> 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

On Fri, 27 Jan 2006 14:23:11 -0600, Dave Peterson
<petersod@verizonXSPAM.net> wrote:

>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 -