>>a2=a2-(49*150*1.05^1)<<
I'm assuming this is a typo and that cell A2 contains:
=A1-(49*150*1.05^1)
Change this to:
=A1-(49*150*1.05^(ROW()-1))
and drag down.
--
Vasant
I assume that the refernce in cell A2 is to A1 and not to A2.
"sirsoto" <[email protected]> wrote in message
news:[email protected]...
>I want to make the following computation in the example cells below;
> Highlight the three cells where I entered my formula; Drag down until
> 300,000 equals zero (or near zero).
>
> a1=300,000-(49*150*1.05^0)
> a2=a2-(49*150*1.05^1)
> a3=a2-(49*150*1.05^2)
>
> The problem i am having is showing a series of exponential increases. I
> need 1.05 (which is 5%) to increase each year. Please advise. Sirsoto
Bookmarks