Hello,
I was wondering if there was a formula that will take a price in say A2 and add 3% per year to current year.
So for every year in-between current year and 2017 a 3% increase would have been added. Then next year the price would change to have another 3% automatically.
I have formulas to get the year 2017 and current year displayed in A1,B1 and have tried to use yearfrac function to make the difference in years automatically.
Any help would be very appreciated.
This might have be done in vba if i cant use a formula i am thinking.
Thanks for any help.
Bookmarks