Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |