LinkBack URL
About LinkBacks
Ken Scanlon 
something like this
=((INDIRECT("M"&ROW(A4))-INDIRECT("N"&ROW(A4)))/INDIRECT("N"&ROW(A4)))
something like this
=((INDIRECT("M"&ROW(A4))-INDIRECT("N"&ROW(A4)))/INDIRECT("N"&ROW(A4)))
not a professional, just trying to assist.....
Thanks duane. I copied and pasted your formula, but it is not working. What is the (A4) stand for or reference?
row(a4) just yields the result of 4 - you could use any cell in row 4. when this formula is copied down it yields 5, 6, etc. my test worked just fine.
I assume you pasted it in the correct row???
duane, I pasted this formula to cell L4 which is the first roll of my calculations. In other words, Today's price is in M4 and yesterday's price is in N4. The formula is apparently not being recognized as a forumula as there is not resulting answer, just the formula itself. If I repaste the original formual to L4 :
=((INDIRECT("M4")-INDIRECT("N4"))/INDIRECT("N4") then is works fine, which is a one day return for this stock. It seems excel is not recognizing the format &row(a4) within the INDIRECT verb? Your formula DOES work in the sense it increments the referenced row number.. I am sure is something that I am leaving out of the?
Thanks again
if I undertand you it sounds like my formula is being pasted as text as opposed to a formula - have you checked this (make sure it starts with = and not ')?
I did double check and the = sign is in front. But it does appear to be treating this as text. Did you key in numerical samples in both M4 and N4?
Ken
Thanks a million duane. It is working now. I was off one cell!!
Ken
i worked the following example
column E F
row 4 3 2
5 4 3
6 5 4
in a4
=((INDIRECT("E"&ROW(A4))-INDIRECT("F"&ROW(A4)))/INDIRECT("F"&ROW(A4)))
in b4
=(E4-F4)/F4
copied down thru row 6
results
column A B
row 4 0.5 0.5
5 0.33 0.33
6 0.25 0.25
both formulas are number and equivilent
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks