Results 1 to 8 of 8
  1. #1
    Golden Oldie smurf's Avatar
    Join Date
    Dec 2004
    Location
    Dunedin
    Posts
    498

    Default Excel Formula for Cashbook entries

    Can someone please help me with setting up an excel formula that will allow me to keep a running record in a cashbook type excel worksheet? I want three columns operating eg Deposit, Withdraw and Balance, set up so that excel automatically calculates the running balance as I enter either a deposit or make a withdraw on the row below.

    Thanks in anticipation.

  2. #2
    Bleakly Optomistic
    Join Date
    Jun 2006
    Location
    Wellington, NZ
    Posts
    1,300

    Default Re: Excel Formula for Cashbook entries

    Assuming the following:

    Column A is Deposit
    Column B is Withdrawals
    Column C is the running balance

    In cell C2, type =SUM($A$1:A1)-SUM($B$1:B1)

    Copy down as need be.

  3. #3
    Golden Oldie smurf's Avatar
    Join Date
    Dec 2004
    Location
    Dunedin
    Posts
    498

    Default Re: Excel Formula for Cashbook entries

    Thanks Bogan. Have tried this formula but it doesn't seem to work I am using Excel 2007 not sure if that creates a problem?

  4. #4
    Bleakly Optomistic
    Join Date
    Jun 2006
    Location
    Wellington, NZ
    Posts
    1,300

    Default Re: Excel Formula for Cashbook entries

    Shouldn't do.

    How are you copying it? Are you selecting the bottom right corner of the cell and dragging?

    Actually, I realised one big fault with that formula I gave. Sorry about that.

    In cell C2, type =SUM($A$2:A2)-SUM($B$2:B2)

    This assumes row 1 has a description of the columns.

    Oh and both deposits and withdrawals are positive. If withdrawals are negative, use =SUM($A$2:A2)+SUM($B$2:B2)
    Last edited by the_bogan; 20-07-2009 at 08:08 PM. Reason: Thought for once.

  5. #5
    Golden Oldie smurf's Avatar
    Join Date
    Dec 2004
    Location
    Dunedin
    Posts
    498

    Default Re: Excel Formula for Cashbook entries

    Ok will try this soon...thank's for your help which is much appreciated

  6. #6
    Bleakly Optomistic
    Join Date
    Jun 2006
    Location
    Wellington, NZ
    Posts
    1,300

    Default Re: Excel Formula for Cashbook entries

    Thank me when you have it sorted. Good luck.

  7. #7
    Can't re Member
    Join Date
    Jun 2008
    Location
    Auckland
    Posts
    277

    Default Re: Excel Formula for Cashbook entries

    I use =C4+A5-B5 in column C.
    This assumes an actual amount in C4 as there has to be a starting balance somewhere.
    Use fill down to populate column C as far as you need to.
    Formula is saying the current balance is the previous balance plus any deposit minus any withdrawal.
    You can format the cells as currency
    As usual there are many different ways of doing the same thing ..

  8. #8
    Golden Oldie smurf's Avatar
    Join Date
    Dec 2004
    Location
    Dunedin
    Posts
    498

    Default Re: Excel Formula for Cashbook entries

    Thanks Othesea......that looks good too. Much appreciated

Similar Threads

  1. Excel Formula
    By Happy Harry in forum PressF1
    Replies: 2
    Last Post: 18-01-2007, 02:26 PM
  2. Excel Formula
    By bk T in forum PressF1
    Replies: 11
    Last Post: 23-07-2004, 01:43 PM
  3. Replies: 5
    Last Post: 30-09-2003, 02:19 PM
  4. Excel IF formula
    By Susan B in forum PressF1
    Replies: 11
    Last Post: 02-12-2002, 07:31 PM
  5. Excel Formula
    By Donald M in forum PressF1
    Replies: 4
    Last Post: 30-07-2002, 04:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •