+ 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, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,803

    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
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  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. 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