Calculating a cell reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting numbers and letters in a single cell to separate cells 1
How do I reference a cell as a row number in a formula? 4
How to reference cell? 1
IF Statements - to include calculation? 5
use cell address 1
How To Have A Cell Be Blank If... 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Cell Reference & formula 5

Back
Top