Please Reply! I Need A Simple Formula

[Johnny3]

im trying to calculate stock returns. i need to apply a formula to
whole column and i dont know how. A1-A2/A2. but how to i do that fo
the whole colum? A2-A3/A3, A3-A4/A4..etc. please hel

 

[JE McGimpsey]

See at least one reply to your post in another ng.

Please don't post the same question in multiple groups. It just
fragments any answers, and potentially wastes the time of those replying
to posts that have already been answered.

See

http://cpearson.com/excel/newposte.htm

 

[Confused]

Your formula is rather confusing. A2-A3/A3?? (A number
divided by itself will always equal 1)

So you could replace it with

A2-1
A3-1
A4-1

Remember divides and multiplys occur before pluses and
minues, so unless you meant (A2-A3)/A3...

 

[K.S.Warrier]

Hi,
Assuming that you want (a1-a2)/a2,(a2-a3)/a3,... in Column, say C
(C1,C2,C3.....)
Then,in C1 put the formula as
=(a1-a2)/a2
Then select C1 and drag from C1 downwards to C2,c3,....(or copy from C1 to
C2,C3 ....)
Will this help you?
Thanking you,
K.S.Warrier