+ Reply to Thread
Results 1 to 2 of 2

Budget allocation: Find out how much can be spent based on other columns

  1. #1
    Registered User
    Join Date
    07-16-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Budget allocation: Find out how much can be spent based on other columns

    I am unsure how to get this formula. I have my budget and i am making the allocation sheet figure out how much I am spending on what for that paycheck. The allocation sheet has 3 paychecks in it. At each paycheck I am putting additional money to debt. What I am stuck on is I want the it automatically figure out how much I can pay per paycheck so that there is enough money left for the 2nd and 3rd paycheck. Then doing same for the 2nd paycheck. If i can not put any money i want it to be 0, if I can put some but not all i want that number to return.

    So i was comparing the income of all then minus expenses but it seems to be more complicated. I hope someone can help.

  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,929

    Re: Budget allocation: Find out how much can be spent based on other columns

    not sure i understand what you are trying to achieve. could you upload a sample of what you would like, with a before and after please?
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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