Using a function to specify a cell
 

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.

Using a function to specify a cell
 

You could use the INDIRECT function.

=INDIRECT("C"&row())

HTH,
Elkar


"trollsoft" wrote:

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.

Using a function to specify a cell
 

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

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.

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

=INDIRECT("C"&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