+ Reply to Thread
Results 1 to 4 of 4

Excel formula to start at one number and arrive at another

  1. #1
    Forum Contributor
    Join Date
    03-14-2016
    Location
    United States
    MS-Off Ver
    MS Office 2013
    Posts
    102

    Excel formula to start at one number and arrive at another

    Hello,

    I have $380,000 in year 4 and $180,000 in year 1 how do I calculate the cells in between to reach that $380,000 number?

    Thanks,
    Max

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,739

    Re: Excel formula to start at one number and arrive at another

    Assuming:
    1. you need one number per year
    2. 180000 is in A1
    3. 380000 is in A4


    In A2 put:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and fill down/copy into A3
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    09-05-2011
    Location
    Essex, England
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    383

    Re: Excel formula to start at one number and arrive at another

    How are you looking at making the jump from year 1 to year 4? a straight even increase?

    are we talking year by year, month by month, week by week, day, by day?

    how many cells are looking at?

    perhaps you could upload a sample workbook with an example of what you're looking to achieve at the end?

  4. #4
    Forum Contributor
    Join Date
    03-14-2016
    Location
    United States
    MS-Off Ver
    MS Office 2013
    Posts
    102

    Re: Excel formula to start at one number and arrive at another

    Awesome, thank you so much!

+ 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. Index match formula unable to arrive a formula
    By srinivasan1965 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 04-17-2015, 06:20 AM
  2. Formula: Start new number where last number stops in a range
    By bjnockle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2015, 11:38 AM
  3. [SOLVED] Index, Find, Row Formula to arrive at the results
    By sjpras in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-20-2015, 01:43 AM
  4. [SOLVED] Formula to arrive back at original figure after adding %
    By sumospim in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-29-2014, 05:15 PM
  5. Formula required to arrive at price
    By Deekappa in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-23-2013, 01:04 PM
  6. CAS EXCEL que je n'arrive pas à résoudre
    By borisoslisly in forum Excel General
    Replies: 3
    Last Post: 06-07-2012, 05:20 AM
  7. Formula problem when trying to arrive at a total
    By verifier in forum Excel General
    Replies: 3
    Last Post: 03-13-2012, 02:01 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