So the below code gets a certain period from an InputBox and posts values for each period in a spreadsheet. What I'm struggling with is applying a multipler for each year. The number of periods is typically not a full year, it's usually a partial year.
For iCol = 0 To nPeriods
ActiveCell(1, iCol).Value = price * quantity
Next
So that's fine for the baseline, but what I need is for all values in year 2, where nPeriods would be 11-23 (I think, not 12-24?), to be multiplied by 5%, then in year 3, the values from year 2 would need to be multiplied by 5% - basically an annual escalation.
For iCol = 0 To nPeriods
ActiveCell(1, iCol).Value = price * quantity
Next
So that's fine for the baseline, but what I need is for all values in year 2, where nPeriods would be 11-23 (I think, not 12-24?), to be multiplied by 5%, then in year 3, the values from year 2 would need to be multiplied by 5% - basically an annual escalation.