+ Reply to Thread
Results 1 to 8 of 8

Salary Monthly Calculation

  1. #1
    Registered User
    Join Date
    01-16-2018
    Location
    Athens, Greece
    MS-Off Ver
    Microsoft Office Exel 2007 (for Windows)
    Posts
    25

    Salary Monthly Calculation

    I want the column SALARY + DEBT to add the remaining 731$ to the next months calculation. And the month after it to add the last two months debt and so on.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Salary Monthly Calculation

    In D2
    Please Login or Register  to view this content.
    In F2
    Please Login or Register  to view this content.
    Drag both down
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    01-16-2018
    Location
    Athens, Greece
    MS-Off Ver
    Microsoft Office Exel 2007 (for Windows)
    Posts
    25

    Re: Salary Monthly Calculation

    Not working :/

  4. #4
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Salary Monthly Calculation

    Can you upload your latest sheet with the calcs in?

  5. #5
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Salary Monthly Calculation

    heres my working one
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-16-2018
    Location
    Athens, Greece
    MS-Off Ver
    Microsoft Office Exel 2007 (for Windows)
    Posts
    25

    Re: Salary Monthly Calculation

    You had made one mistake in your first formula. Thanks

  7. #7
    Registered User
    Join Date
    01-16-2018
    Location
    Athens, Greece
    MS-Off Ver
    Microsoft Office Exel 2007 (for Windows)
    Posts
    25

    Re: Salary Monthly Calculation

    @JohnTopley I've marked with 3 comments what I want.
    Attached Files Attached Files

  8. #8
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    Re: Salary Monthly Calculation

    in F2

    =IF(D2<>"",SUM($D$2:D2)-SUM($E$2:E2),"")

    You can also remove column B

+ 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. Replies: 1
    Last Post: 11-22-2017, 05:27 AM
  2. Finding value based on tax status and monthly salary
    By etuckram in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-29-2017, 04:26 PM
  3. Monthly salary + commission - tax deductions
    By gaz76 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-25-2015, 10:44 AM
  4. [SOLVED] Need formula for prorating monthly salary based on hire/fire date and annual salary.
    By Excel_Help_Pls in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-06-2015, 12:56 AM
  5. monthly salary payroll
    By miguel_angeo in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-21-2013, 09:38 PM
  6. [SOLVED] Count Allowance Percent Based On Monthly Salary
    By redza in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2013, 10:47 PM
  7. Replies: 3
    Last Post: 07-26-2012, 04:11 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