+ Reply to Thread
Results 1 to 4 of 4

Formula for budget trending

  1. #1
    Registered User
    Join Date
    01-19-2018
    Location
    Sioux Falls, SD
    MS-Off Ver
    Office 365
    Posts
    3

    Formula for budget trending

    I have a very simple spreadsheet that shows budgeted amount for a month, billed amount, and an over/under amount monthly. I have these summed in the end column for total budget, total billed amount and where this ends up over/under budget. I'm trying to figure out a formula that calculates based on the total amount billed, if the spend continues as budgeted over the remaining months, will we end up over or under budget? I've attached a sheet showing a sample. The cells highlighted in yellow are what I'd like to populate. Again, based on actuals spent, it we continue to spend the budgeted amount for the remaining months, are we trending over or under budget. Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    re: Formula for budget trending

    Put this in I3 and pull down to I4:
    Please Login or Register  to view this content.
    that do it for you?
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    01-19-2018
    Location
    Sioux Falls, SD
    MS-Off Ver
    Office 365
    Posts
    3

    re: Formula for budget trending

    That doesn't quite work out. Example...I filled out the remaining months in the "billed amount" with $500 per month as budgeted, expecting then to show that I would end up $200 over budget in I4...but the average function showed me at -33. Thanks.

  4. #4
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    re: Formula for budget trending

    That's not what you asked for in the first post though?

    You're asking for a projection based on existing trends in post #1, but in post #3 it sounds like you're asking for just what the current over/under is?

    What is the mathematical formula that you need? Don't worry about the excel syntax, just give me the formula.

+ 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 for budget trending
    By heathers3245 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-19-2018, 07:59 PM
  2. Replies: 2
    Last Post: 03-15-2017, 03:14 AM
  3. Nested IF statement to show under budget, within a % of budget, over budget
    By clafleur in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2015, 10:36 AM
  4. Replies: 2
    Last Post: 12-10-2013, 02:30 AM
  5. Trending formula and indicators
    By Raging in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-22-2013, 10:02 AM
  6. 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
  7. [SOLVED] Trending Formula Results by Date
    By sony654 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-01-2006, 10:40 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