Please help with programming
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 |
Please help with programming
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 |
Please help with programming
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 |
All times are GMT +1. The time now is 01:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com