+ Reply to Thread
Results 1 to 2 of 2

Calculating a cell reference

  1. #1
    DeanGriffith01
    Guest

    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. #2
    Pete
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1