Results 1 to 9 of 9

How to find a target value from a list of calculated and ordered values

Threaded View

  1. #1
    Registered User
    Join Date
    05-22-2012
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2010
    Posts
    16

    How to find a target value from a list of calculated and ordered values

    Please see attachment. I have a list of values, D2:02 that are calculated by adding a monthly contribution found in B2 to the previous month's balance.
    Is there a formula/calculation that I can place in B4 that will return the first month that the goal can be obtained? For example, if the goal was $70,000,
    then Jun-15 should be returned.

    Thank you.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for number of perfect ordered needed to achieve certain target.
    By kokoli84 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2014, 08:06 PM
  2. Replies: 2
    Last Post: 09-27-2013, 02:31 AM
  3. Counting Unique Values and Generating an Ordered List
    By amerain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2013, 08:08 PM
  4. Replies: 2
    Last Post: 12-14-2012, 01:17 PM
  5. Replies: 5
    Last Post: 10-26-2008, 06:56 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