Please Reply! I Need A Simple Formula
 

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


--
Johnny3
------------------------------------------------------------------------
Johnny3's Profile: http://www.excelforum.com/member.php...o&userid=16756
View this thread: http://www.excelforum.com/showthread...hreadid=319584

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


In article ,
Johnny3 wrote:

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

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...

-----Original Message-----

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

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

"Confused" wrote:

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...

-----Original Message-----

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