Help for excel formula

[JE McGimpsey]

Assuming there's nothing below A12 (and no blanks):

=INDEX(A:A,COUNTA(A:A))

 

[KL]

Hi Tim,

Try this:

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))

Regards,
KL

 

[Tim]

How can I create an excel forumala that will just show the last number
4450.007?

1-Jul 1-Aug 1 month % increase
1569 1700 8.35%

1 1841.938
2 1995.726
3 2162.354
4 2342.895
5 2538.51
6 2750.457
7 2980.1
8 3228.916
9 3498.507
10 3790.606
11 4107.094
12 4450.007

 

[Tim]

Thanks for the quick reply but I think I asked the wrong question. Let me
go into more detail. On July 1st my value is 1569, then on August 1 the new
value is 1700, which is a 8.35% increase. After 12 months of 8.35% increase
of each month my final value is 4450.007. What is the formula that I can
input 1569,1700(or 8.35%) then the output will be 4450.007?

 

[JE McGimpsey]

OK. Assuming:

J K L
1 1-Jul 1-Aug 1 month % increase
2 1569 1700 =K1/J1-1

Then

A1: =K1*(1+$L$1)
A2: =A1*(1+$L$1)

copy A2 down to A12.

Alternatively:

A1: =$J$1*(1+$L$1)^(ROW()+1)

Copy A1 down to A12

or even:

A1: =$J$1*($K$1/$J$1)^(ROW()+1)

Copy A1 down to A12

 

[KL]

Hi Tim,

Try this assuming cell [A1]=1569 and [B1]=8.35%:

=A1*(1+B1)^13

or simply:

=1569*(1.0835)^13

Regards,
KL

 

[JE McGimpsey]

If you still want to put the result in only one cell:

=K1*(K1/J1)^12

 

[Tim]

KL,

Thanks that worked.

Also I found the FV excel formula helpful, but I like yours better:
=FV(0.0835,13,0,1569)*-1

Tim

Hi Tim,

Try this assuming cell [A1]=1569 and [B1]=8.35%:

=A1*(1+B1)^13

or simply:

=1569*(1.0835)^13

Regards,
KL

Thanks for the quick reply but I think I asked the wrong question. Let me
go into more detail. On July 1st my value is 1569, then on August 1 the
new
value is 1700, which is a 8.35% increase. After 12 months of 8.35%
increase
of each month my final value is 4450.007. What is the formula that I can
input 1569,1700(or 8.35%) then the output will be 4450.007?