+ Reply to Thread
Results 1 to 4 of 4

Need formula for a check register (balance column)

  1. #1
    Registered User
    Join Date
    06-20-2008
    Posts
    1

    Question Need formula for a check register (balance column)

    Can someone please tell me how to write a formula for the cells in the balance column to deduct debits and add credits?
    Example: Col A Debit, Col B Credit, Col C Balance
    I want a formula in Col C to subtract Col A and add Col B.

    Thank you.

  2. #2
    Forum Contributor
    Join Date
    06-14-2008
    Posts
    153
    If I understood you correctly then the formula is strait forward.

    In cell C1 enter:

    =B1 - A1

    and so on for the rest of the cells.
    Welcome to: http://www.exceldigest.com/myblog/
    "Excel help for the rest of us"

  3. #3
    Registered User
    Join Date
    08-23-2008
    Location
    Meridian, ID
    Posts
    4
    Type Check Register in the help search bar in Excel. There's a groovy template to download for free. I just looked that up myself earlier today. :-)

  4. #4
    Registered User
    Join Date
    08-21-2010
    Location
    Portland, OR
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Need formula for a check register (balance column)

    there is a free Excel check register at http://1ceware.webs.com/downloads.htm

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1