+ Reply to Thread
Results 1 to 3 of 3

Amending Balance when Debit and Credit Values entered.

  1. #1
    Registered User
    Join Date
    09-15-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    82

    Amending Balance when Debit and Credit Values entered.

    Hi Everyone

    Hope someone can help me here.

    JBeaucaire helped me with a problem yesterday, http://www.excelforum.com/excel-form...t-balance.html, that was excellent and did exactly what I asked for and I thank him again for that.

    At work today my boss gave me a hard time as I misunderstood what he wanted so again I'am looking for some help.

    What hopefully someone can help me with is there is a Balance in Cell G3, This needs to stay as it is without changing. However each time a Debit or Credit is added in Columns D or E the new Balance should show in the corresponding cell in Column G. I hope I have explained that sufficiently.

    Thank you all in advance

    Ortz
    Attached Files Attached Files
    Last edited by Ortz; 05-22-2014 at 07:25 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,740

    Re: Amending Balance when Debit and Credit Values entered.

    See attached. Assumed these were expense items so increased debits and reduced credits.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-15-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: Amending Balance when Debit and Credit Values entered.

    Hi Alan

    Thank you for that, its exactly what was needed. Many thanks for your time and help

    Thank you

    Ortz

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Debit or Credit Account Balance.
    By Ortz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-21-2014, 07:19 PM
  2. debit-credit
    By tiki33 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2014, 03:13 AM
  3. Debit credit formulas
    By SAMEEP in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 11-08-2011, 01:13 PM
  4. Help with a Debit Credit Table
    By LJRich39817 in forum Excel General
    Replies: 2
    Last Post: 03-01-2011, 08:57 AM
  5. [SOLVED] Credit and Debit formating
    By Tim in forum Excel General
    Replies: 1
    Last Post: 05-01-2005, 05:33 PM

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