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

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

Ok thanks that works .


"Bernard Liengme" wrote in message
...
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

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

"S S" wrote:

Ok thanks that works .


"Bernard Liengme" wrote in message
...
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