Excel help

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

  1. iMacZealot macrumors 68020

    Mar 11, 2005
    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?

  2. MacDawg macrumors Core


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

    Woof, Woof – Dawg [​IMG]
  3. swiftaw macrumors 603


    Jan 31, 2005
    Omaha, NE, USA
    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.
  4. iMacZealot thread starter macrumors 68020

    Mar 11, 2005
    Yeah, that worked, thanks. Originally, I had it show the difference, but in absolute value (ABS formula.) Now it works great.

Share This Page