software

Say I want to specify the cell whose column is C and whose row is the
returned value of a function (say row()). How would I accomplish that?

The incorrect syntax would be Crow(). What would be a way to do it correctly?

thanks.

You could use the INDIRECT function.

=INDIRECT(quot;Cquot;amp;row())

HTH,
Elkarquot;trollsoftquot; wrote:

gt; Say I want to specify the cell whose column is C and whose row is the
gt; returned value of a function (say row()). How would I accomplish that?
gt;
gt; The incorrect syntax would be Crow(). What would be a way to do it correctly?
gt;
gt; thanks.

On Thu, 9 Mar 2006 16:13:26 -0800, trollsoft
gt; wrote:

gt;Say I want to specify the cell whose column is C and whose row is the
gt;returned value of a function (say row()). How would I accomplish that?
gt;
gt;The incorrect syntax would be Crow(). What would be a way to do it correctly?
gt;
gt;thanks.

=ADDRESS(ROW(),3) would return the cell address

=INDIRECT(quot;Cquot;amp;ROW()) or
=INDIRECT(ADDRESS(ROW(),3))

would return the contents of the cell at that address. However, if the
cell is blank, these formulas will return a zero.--ron