+ Reply to Thread
Results 1 to 6 of 6

Formula to show deductions and balance

  1. #1
    Registered User
    Join Date
    03-17-2014
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    47

    Formula to show deductions and balance

    What type of formula do I have to write to show a value in one cell then deductions in the next cell. I want to keep a value in cell A1 then in b1, b2, b3,b4 etc the amount taken from cell A1 so it shows my remaining balance.

    Thank you

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Formula to show deductions and balance

    Maybe =A1-10
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-17-2014
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Formula to show deductions and balance

    Hello, What I'm looking to do is some type of inventory deductions. I have a starting value say $5,000.00 in cell A1. Payments come in every week so I want to enter the payments line by line. I want to see each payment deducted from the $5,000.00.

    Is this possible?

    Thanks,

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Formula to show deductions and balance

    Upload a sample workbook

  5. #5
    Registered User
    Join Date
    03-17-2014
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Formula to show deductions and balance

    Hello FDibbins,
    Thanks for your help, I've been assigned another project and will have to come back to this. However I do have a new question, not sure if you can help or if I should post it to the forum.

    thanks!!

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Formula to show deductions and balance

    Sure post in a new thread and lets see how we can help

+ 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. Formula to work out deductions based on hours and time
    By elmobram22 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2013, 12:13 PM
  2. Formula to show current day balance on a different sheet
    By wiljar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2013, 04:51 AM
  3. Formula to work out UK Tax deductions?
    By Sepia in forum Excel General
    Replies: 2
    Last Post: 01-11-2008, 09:00 AM
  4. [SOLVED] Getting the Check Register Balance to show on another Sheet
    By thenderson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-21-2005, 03:35 PM
  5. How do I setup a formula for payroll deductions in excel
    By Skeeter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2005, 06:06 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