Excel help

Discussion in 'Community Discussion' started by iMacZealot, Jul 22, 2008.

Most Liked Posts
  1. iMacZealot, Jul 22, 2008

    iMacZealot macrumors 68020

    Joined:
    Mar 11, 2005
    #1
    I'm using Excel again, and I'm a little rusty. I'm using it not only because I don't have iWork, but I'm using it to keep track of my teenage finances. Each line has a date, the total amount of money from all of my funds, the total, and I want a difference column to show the difference between the last entry's total and this entry's total. Sometimes it may be positive, but sometimes negative. I can't remember the function that equates that.

    Anyone remember?

    Thanks.
     
    share
    + Quote Reply
  2. MacDawg, Jul 23, 2008

    MacDawg macrumors P6

    MacDawg

    Joined:
    Mar 20, 2004
    Location:
    "Between the Hedges"
    #2
    Maybe a screen shot visual would help to more clearly define what you are looking for

    Woof, Woof – Dawg [​IMG]
     
    share
    + Quote Reply
  3. swiftaw, Jul 23, 2008

    swiftaw macrumors 603

    swiftaw

    Joined:
    Jan 31, 2005
    Location:
    Omaha, NE, USA
    #3
    Suppose your totals are stored in column B. Then in column C, you would have "=B(current row) - B(previous row)" So for example, in C2 you would type "=B2-B1" you can then copy and paste this down the entire C column to do the rest of the entries.
     
    share
    + Quote Reply
  4. iMacZealot, Jul 23, 2008

    iMacZealot thread starter macrumors 68020

    Joined:
    Mar 11, 2005
    #4
    Yeah, that worked, thanks. Originally, I had it show the difference, but in absolute value (ABS formula.) Now it works great.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page