Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Reference Previous Cell

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    New Horizons UK
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Everyone, whatever cell i use for a formula how do i tell it to look at the cell before it.
    example, =sum(b1-a1)this is OK
    but i want to replace 'a1' with
    'the cell before the one i am putting in the formula'
    you know it is a1 so do i but i dont want to reference it that way, just tell it to look at the previous cell. can this be done please, regards john

    _________________
    Many Thanks To All You Helpers

    [ This Message was edited by: TTEMAN on 2002-02-26 08:15 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That's the point of Absolute and Relative references. For example, if you put in A2

    =A1

    and in B2

    =$B$1

    and drag them down, you should see in A3

    =A2

    and in B3

    =$B$1

    So, if you need a formula to look at the formula above it and you're "standing" in C3459, then just use

    =C3458

    and drag it down !
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    actually, that is exactly what you are doing already. B1-A1 is saying take cell B1 and subtract the cell before it in the same row.

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
  •