| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function that Returns address of that cell? | Excel Worksheet Functions | |||
| Excel 2000: sum function automated? | Excel Discussion (Misc queries) | |||
| Change Cell properties by Function | Excel Worksheet Functions | |||
| Reading Cell Function??? | Excel Worksheet Functions | |||
| IF Function to test formula in a cell | Excel Worksheet Functions | |||
Hybrid Mode
