If you really want simple interest (no compounding) use in C2:
=$B$2*(1+2.5%*COLUMN(A2))
Copy across the row

For compounding use =B2*(1+2.5%)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"S S" wrote in message
. uk...
In cell B2 u have a monetry value, in C2 it increases 2.5% in cell D2 it
increases a further 2.5% ansd so on for 10 years, In other words it adds
on 2.5% evry year.I currently do it manually, is there an easy formula
that I could use to do this so that I would just put a value in B2 and
have it do this.

B2 Value
In C2 value +2.5%
In D2 value +5%
In E2 value +7.5% continuing this increase of 2.5% to L2

thanks