Help with Numbers

Discussion in 'Mac Apps and Mac App Store' started by ghall, Aug 15, 2007.

  1. ghall macrumors 68040

    ghall

    Joined:
    Jun 27, 2006
    Location:
    Rhode Island
    #1
    Okay, I'm trying to get a chart of my checking account all made out. The chart has 5 columns, Date, Transaction, Withdrawal, Deposit, and Balance. First off, I need to create a formula that will take the value of the previous Balance cell, add the value entered for the Deposit cell, and subtract the value entered for the Withdrawal cell. Similar to what the programs Cashbox or ChaChing do. (I'd just use one of those programs, but I like having the customization of a spreadsheet)

    Also, since I'm a very visual person, I want to be able to have a graph of my account balance by date.

    If you need me to clear up any of my questions, just let me know. Sometimes I can be bad at explaining things in writing.
     
  2. William9 macrumors newbie

    Joined:
    Aug 19, 2007
    #2
    You want a column showing a running balance, right?
    Make a formula which takes the value of the cell above, then adds the values in the cells to the left that either have a +number or a -number. Then drag the formula down the column so the the formula a changes to the proper references for each row.
     

Share This Page