+ Reply to Thread
Results 1 to 2 of 2

Budget Remaining Calculations Formula

  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    KC, MO
    MS-Off Ver
    Excel 2003
    Posts
    2

    Budget Remaining Calculations Formula

    This a budget spreadsheet laid out in 13 weeks. In cell A4 is the Budget per week (28,000$). In cells B4 to N4 (13 cells for 13 weeks) are where entries are made on how much was spent.

    In cell P4, Q4, and R4 I have monthly budget remaining totals, which takes the budget * number of weeks in the month - amount spent in those weeks.
    P4 is =A4*4-SUM(B4:E4)
    Q4 is =A4*4-SUM(F4:I4)
    R4 is =A4*5-SUM(J4:N4)

    What I want cell O4 (current month remaining budget) to do is when entries are only in cells for the first month(B4,C4,D4,E4), to show cell P4's value. When entries are in the 2nd month(F4,G4,H4,I4), to use Q4's value. When entries in the 3rd month(J4,K4,L4,M4,N4), to use R4's value.

    I've tried numerous variations with IF and AND to no avail. Any ideas? Thanks
    Last edited by ASpence87; 10-25-2013 at 01:38 PM.

  2. #2
    Registered User
    Join Date
    10-25-2013
    Location
    KC, MO
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Budget Remaining Calculations Formula

    Update, I got it. I used =IF(J4>0,R4,IF(F4>0,Q4,IF(B4>0,P4)))

    I was using =IF(B4>0,P4,IF(F4>0,Q4,IF(J4>0,R4))), then tried reversing the order and it worked.

+ 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. budget formula. 2 different formulas for yearly budget SUMIF?
    By italianstallion in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2013, 05:20 AM
  2. Replies: 0
    Last Post: 07-26-2012, 02:09 AM
  3. Replies: 1
    Last Post: 12-31-2009, 07:44 PM
  4. Trying to figure out some budget calculations and formatting?
    By stebesplace in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-26-2007, 04:27 PM
  5. Remaing Time Calc
    By wac61 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-13-2006, 03:08 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