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?
--
-eben QebWenE01R@vTerYizUonI.nOetP royalty.mine.nu:81
A neutron walks into a bar; he asks the bartender,
"How much for a beer?" The bartender looks at him,
and says "For you, no charge." -- GooberMcFly on Fark
-----------------------------------------------------------------------
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:15 EDT