Need Help Programming

[RandyJ]

I want to take a material cost and add for an increase for inflation fo
an "x" number of years.

i.e. My material cost in 1995 for $100.
Material has gone up by 3% per year.
So I want to add 3% to my material per year for the last 9 years.

Each cell I will enter the material cost, % of increase and number o
years.

Thanks

 

[AlfD]

Hi!

If you want to see each year's figure:

Put 1995, 1996,..... across row 1
In A2 put 100
In B2 put =A2*1.03
Copy across row 2.
Format the row as currency.

You might sometime want to use variable inflation rates instead of
constant 3%.
If so, the 1.03 would be 1.04 for 4% etc.

You might also want to look at a different amount from $100, in whic
case just put that different amount in A2.

Al