Forum Discussion
Exel formula needed
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?
Nice to hear that! Please consider marking the answer as a solution if you think you have solved your issue!
6 Replies
Hi, please see attached document with proposed solution. Is this what you are looking for?
=IF($E$9>=E19,1000+$D$9,1000)
Assuming there is a base amount of 1000 each year (which will be added to the fixed 1500 cost). This can be replaced by any formula you want or whatever value might interest your case.
Martin
Martin_Angosto thanks so much works perfectly - legend!
Nice to hear that! Please consider marking the answer as a solution if you think you have solved your issue!
