Please help with 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

 

[marston.gould]

Function Inflate(amount As Double, percent As Double, year as Double)
Inflate = amount * (1+percent) ^ year
End Function
It will then be available as a function in your function menu

 

[marston.gould]

Function Inflate(amount As Double, percent As Double, year as Double)
Inflate = amount * (1+percent) ^ year
End Function
It will then be available as a function in your function menu