Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: circular referencing?

  1. #1
    Guest

    Default

    i have a figure in a cell, in the next cell to it i type a new number, i want the second cell to show the result of subtracting the first cell from the second cell, iwant the result to display in the second cell, iwant the reference to always be the previous cell whatever its address. i am a novice, be gentle with me.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A formula cannot refer to itself. Therefore, you cannot enter =A2-A1 into A2 without getting a circular reference error.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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