On Fri, 12 Dec 2008, blee2@tampabay.rr.com wrote:
> Thus draeath hast written on Fri, Dec 12, 2008 at 03:21:43PM -0500, and, according to prophecy, it shall come to pass that:
>>> =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.
>
>> I wonder if there is anything that forces evalualtion? I tried a quick
>> test with eval() but it doesn't do what I would expect, and I fail to
>> find a function reference in help.
>
> Try with single quotes " ' " or graves " ` "....
There's no EVAL function, but both
=CELL("contents"; 'address(2;23;2)')
and
=CELL("contents"; `ADDRESS(2;23;2)`)
give #NAME? ("unknown function"). Sigh. There HAS to be a way...
-- -eben QebWenE01R@vTerYizUonI.nOetP royalty.mine.nu:81 TAURUS: You will never find true happiness - what you gonna do, cry about it? The stars predict tomorrow you'll wake up, do a bunch of stuff and then go back to sleep. -- Weird Al ----------------------------------------------------------------------- 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:02:15 EDT