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

--
Randy
-----------------------------------------------------------------------
RandyJ's Profile: http://www.excelforum.com/member.php...fo&userid=1514
View this thread: http://www.excelforum.com/showthread.php?threadid=26775

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