+ Reply to Thread
Results 1 to 4 of 4

Formula to deduct from one balance first then the other please?

  1. #1
    Registered User
    Join Date
    10-15-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    37

    Formula to deduct from one balance first then the other please?

    So i have 100 in A1, and 110 in A2 - we can say they are £ and A1 is winnings A2 is total balance.

    (A1 always forms part or whole of A2)

    i would like purchases to get deducted from the balance in A2 first. So in the event of a purchase of £5, then just A2 is reduced to 105 - no problem i have that covered.

    In the event of a following £25 purchase, (working now from 105), i would like A2 to reduce to 80, but A1 also to reduce to 80...

    i also have deposits1 and deposits 2 to cover, but i am happy to come to that, in the hope this is enough information to get started? Purchases can come from B:B if needed.

    Any help much appreciated

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formula to deduct from one balance first then the other please?

    pls attach a sample excel file with expected result
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    10-15-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Formula to deduct from one balance first then the other please?

    Thanks Siva, sorry how do i attach an excel?

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formula to deduct from one balance first then the other please?

    see the imageAttach A File.jpg

+ 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] Add & Deduct Formula :confused:
    By pipsmultan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-16-2014, 02:04 AM
  2. Deduct from arrears before installment then show balance outstanding
    By ExcelBrian in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-10-2014, 08:47 AM
  3. Need a formula to deduct payments from balance
    By dmxxmd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-04-2014, 01:46 AM
  4. formula tuesday deduct 2 day
    By choy96 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-27-2013, 01:02 PM
  5. Formula to deduct 1 from c6 if A6 greater than C3
    By Jg396 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-15-2013, 09:01 PM
  6. Replies: 2
    Last Post: 03-22-2012, 01:17 PM
  7. Replies: 6
    Last Post: 12-22-2009, 03:31 AM

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