Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating a cell reference
Hi, it is possible to get excel to recognise a cell reference based on a
calculation? I have this formula which gives me a number that i'd like to use as a row number. =IF(N2 1,(CELL("Row",L3)+(CELL("Contents",N3))),IF(N2 =1,(CELL("Row",L3)+(CELL("Contents",N3)-1)),"Not Parent")) I also know the column letter that I'd like to use, but have no idea how I can marry the 2 together so that I can then use the CELL("Contents", ) function on the cell and display the contents in a particular cell. Any ideas, or if I'm talking gibberish please give me a shout. Thanks Dean |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating a cell reference
Have a look at the INDIRECT( ) function in Help - I think you will find
that it will help you to do what you intend. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) |