increasing percentage

[S S]

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

 

[Bernard Liengme]

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%)

 

[S S]

Ok thanks that works .

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%)

 

[Guest]

SS -- Another approach:

A B
1 Init $
2 1 =$b$1*(1.025^a2)
3 2 copy down

Or you could set up the interest rate in C1 and use:

=$B$1*((1+$C$1)^A2)

to modify the interest rate as you go.

HTH