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

RE: Excel, again :)



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