Please help with programming

  • Thread starter Thread starter RandyJ
  • Start date Start date
R

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