On Fri, 12 Dec 2008, Paul Bransford wrote:
> On Fri, 2008-12-12 at 03:05 -0500, Eben King wrote:
>> Anybody good at OOCalc or maybe Excel?
>>
>> This works, and gives the right answer ("W$2"):
>> =ADDRESS(2;23;2)
>>
>> This works, and gives the right answer (the contents of W2, currently 85):
>> =CELL("contents"; W$2)
>>
>> This gives a "#REF!" error:
>> =CELL("contents"; ADDRESS(2;23;2))
>>
>> What's wrong? How can I get the contents of (computed, not hardcoded) W2?
> Are the quotes included in the return of ADDRESS()? That may be the
> problem...
Like this?
=CELL("contents"; "ADDRESS(2;23;2)")
That still gets me "#REF!". I think what it's doing is interpreting
ADDRESS(2;23;2) as a string, not evaluating it and taking the return value.
-- The mnky gibbering and screeching used to keep me up at night, although in the lst week or so it's prtty mch tailed off to nthng. The smell has gttn noticbly worse in the last cple of days, too. The next time I get a barrl full of mnkys, I'm going to try taking the lid off. -groo, AFCA ----------------------------------------------------------------------- This list is provided as an unmoderated internet service by Networked Knowledge Systems (NKS). Views and opinions expressed in messages posted are those of the author and do not necessarily reflect the official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 18:00:50 EDT