|
PureBytes Links
Trading Reference Links
|
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
|