Closed Thread
Results 1 to 2 of 2

predict future costs

  1. #1
    Registered User
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    MS Office 10
    Posts
    42

    predict future costs

    Hi

    ive got a forecast spreadsheet and ive used simple formulas to predict future expenses for the next two years.

    i need to be able to predict future costs quicker instead of changing formulas per line item.

    i've completed 2018 & 2019 costs as per example as what i would like it to look like however not all cost categories use the same rates - see rates tab.

    i would like to use different rates as in columns M&N in rates tab as well as different averages to predict future costs (see columns D thru G in rates tab as well)

    and i've got a one-off cost in 2018 for global meeting that i need to forecast in Jan only - i assuming to simply add that value to Jan

    does anybody know of data validation formula to simply change the values for future expenses more quicker instead of changing formulas per line item?

    thanks
    Attached Files Attached Files

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

    Re: predict future costs

    Duplicate thread...
    https://www.excelforum.com/excel-for...ure-costs.html
    I am closing this 1 now
    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

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] data validation and predict future costs
    By paulunh11 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-11-2017, 11:16 AM
  2. A code/formula to predict future outcomes of arrangement?
    By a1b2c3d4e5f6g7 in forum Excel General
    Replies: 4
    Last Post: 05-09-2014, 03:32 PM
  3. Replies: 3
    Last Post: 01-17-2014, 07:42 PM
  4. [SOLVED] Predict future value and date in a table
    By bajdr47 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-07-2013, 04:39 AM
  5. Predict a Future Date?
    By Brook963 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-14-2011, 09:05 AM
  6. How do I forecast/predict future values ?
    By new2all in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2007, 08:07 AM
  7. Formula to predict a future date
    By Bill Eagle eye in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2005, 10:35 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