Hi there,

I am trying to show a specific fixed annual cost in a spreadsheet each year for a specified period. The cost is shown in a specific cell (D9) but only applies annually for a certain number of years (this figure is stated in cell E9).

I have established a row of policy years number 1 to 10 from E19 to N19 but only want the fee to show in the relevant number of cells. For example if the cost is £1,500 in cell D9 but the number of years it is applicable for in 7 (as stated in E9) I would only want it showing in cells E19 to L19 (i.e. years 1 to 7). Does anyone know how to create this formula?

​Hi there, I am trying to show a specific fixed annual cost in a spreadsheet each year for a specified period. The cost is shown in a specific cell (D9) but only applies annually for a certain number of years (this figure is stated in cell E9). I have established a row of policy years number 1 to 10 from E19 to N19 but only want the fee to show in the relevant number of cells. For example if the cost is £1,500 in cell D9 but the number of years it is applicable for in 7 (as stated in E9) I would only want it showing in cells E19 to L19 (i.e. years 1 to 7). Does anyone know how to create this formula?  Read More

​