PureBytes Links
Trading Reference Links
|
Gary,
But I want to read the "values" from the other cells, not strings.
Imagine the other cells contain 93 and 94.
Colin
-----Original Message-----
From: Gary Fritz [mailto:fritz@xxxxxxxx]
Sent: Tuesday, September 16, 2003 9:41 AM
To: cwest
Cc: omega-list@xxxxxxxxxx
Subject: Re: Excel, again :)
The XLTRADERS yahoogroup is a better place to find Excel gurus...
> In this array {=STDEVP((LN(data!C3:C94/data!C2:C93)))} I want to
> change the values C94 and C93 to values I read from another cell.
> Appreciate any suggestions.
Try replacing C93/4 with INDIRECT("anothercell") if the other
cell contains a string cell reference. So e.g. if A1 contains
the string "C94" and B1 contains "C93", this formula will produce
the same result:
...LN(data!C3:INDIRECT(A1)/data!(C2:INDIRECT(B1)) ...
If the other cell contains an offset from some other cell, you
can use the OFFSET() function:
...LN(data!C3:OFFSET(BaseCell,RowOffset,ColOffset)/ ...
There is also the INDEX() function, and probably 3 or 4 other
ways to solve it, but those should do the trick.
Gary
|