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

Thread: formulas

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have created a formula in cell A3 that subtracts A2 from $A$1, where A2 nd A1 refers to a simple number formats, no formulas. My formulas written in cell A3 reads: =$A$1-A2). However, when inserting a new row, in order to enter a new cell of data immediately above the formula, I notice that the formula does not change and continues to refer to A2, the "old" cell entry. However, I desire the formula to change to =$A$1-A3 and then to =$A$1-A4 when another new row is inserted and so on. . Basically I am trying to find simple non-vba method (of one exists) that will force this formula refer to the "new cell" I insert in the column immediately above it and subtract it from $A$1.

    Any suggestions on writing a formula on will adjust automatically when a new row is inserted? Mahalo in advance.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    Aloha,

    In A3 enter:

    =$A$1-OFFSET(A3,-1,0,1,1)

    Aladin

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
  •