[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel, again :)



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