Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value
This is what I am trying to do. I am trying to give reference of a cell by
adding number to that cell. Means I am trying say cell D5= C12. But I would like to set up a formula stating C(5+7) Any help appreciated. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value
Try the INDIRECT function. Look it up in Excel help.
-- David Biddulph "Learn Excel" wrote in message ... This is what I am trying to do. I am trying to give reference of a cell by adding number to that cell. Means I am trying say cell D5= C12. But I would like to set up a formula stating C(5+7) Any help appreciated. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell value
Have a look in Help for the INDIRECT function
Let G1 have the value 5 and G2 the value 7, then the formula =INDIRECT("C"&G1+G2) will be equivalent to =C12 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Learn Excel" wrote in message ... This is what I am trying to do. I am trying to give reference of a cell by adding number to that cell. Means I am trying say cell D5= C12. But I would like to set up a formula stating C(5+7) Any help appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |