Hi all,

Just wondering if anyone could please help with the following :

I have a spreadsheet that has a starting value for a yearly payment in cell D16.
This yearly payment is going to increase by a percentage specified in cell M11 over the next fifty years.

I want to display a column showing the figures increasing over the first ten years and have done so using cells D16 to D25 and having the following formula in them :

=(D16/199*M11)+D16 in cell D17
=(D17/199*M11)+D17 in cell D18 etc etc...

This works just fine. I only want to show the increased fee for the first 10 years sequentially. At the end of the list of 10 years I then want to show what the fee will be in years 25 and 50. (IE: in cells D26 and D27).

Any ideas how to calculate this please ? Many Thanks.

Si.