+ Reply to Thread
Results 1 to 4 of 4

troubleshoot absolute value

  1. #1
    Sus
    Guest

    troubleshoot absolute value

    I'm trying to have a cell (e.g. A19) reference a certain cell value (e.g.
    from A3) and for that cell (A19) to maintain the same value from A3 after
    adding another row above A3. I've put in $A$3 in cell A19, but once I add a
    row above the third row, the now A20 automatically changes to ($A$4). How do
    I keep the absolute value?

  2. #2
    mbarron
    Guest

    Re: troubleshoot absolute value

    Try this one:

    =INDIRECT("A3")


  3. #3
    Ron Coderre
    Guest

    RE: troubleshoot absolute value

    How about:
    A19: =INDIRECT("A3")

    Does that help?

    --
    Regards,
    Ron


    "Sus" wrote:

    > I'm trying to have a cell (e.g. A19) reference a certain cell value (e.g.
    > from A3) and for that cell (A19) to maintain the same value from A3 after
    > adding another row above A3. I've put in $A$3 in cell A19, but once I add a
    > row above the third row, the now A20 automatically changes to ($A$4). How do
    > I keep the absolute value?


  4. #4
    Bob Phillips
    Guest

    Re: troubleshoot absolute value

    =INDIRECT("A3")

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Sus" <Sus@discussions.microsoft.com> wrote in message
    news:0B24BBAB-DE70-4AC4-8F59-58263380ACFF@microsoft.com...
    > I'm trying to have a cell (e.g. A19) reference a certain cell value (e.g.
    > from A3) and for that cell (A19) to maintain the same value from A3 after
    > adding another row above A3. I've put in $A$3 in cell A19, but once I add

    a
    > row above the third row, the now A20 automatically changes to ($A$4). How

    do
    > I keep the absolute value?




+ 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