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" wrote in message
...
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