Results 1 to 3 of 3

Math Help - Percentage complete

  1. #1
    Newbie
    Joined
    Sep 2011
    Posts
    4

    Percentage complete

    I've been trying to figure out how to calculate what percent of the way to a target one number is.

    Eg:
    Code:
    Starting Value     Target Value     Current Value     Percent Complete 
    100                    300                  100                   0
    100                    300                  150                   25 
    100                    300                  200                   50 
    100                    300                  250                   75 
    100                    300                  300                   100
    Or:
    Code:
    Starting Value     Target Value     Current Value     Percent Complete 
    70                     140                  70                    0 
    70                     140                  105                   50 
    70                     140                  140                   1
    The three left hand columns I have, the right hand I need to calculate, but after spending ages failing in Excel, the answer eludes me. If I get it to work with one value, it doesn't work with another. For the lower table,
    Code:
    D=1-((B-C)/A)
    seems to work, but the upper table,
    Code:
    D=((C+A)/(B-A)-1)
    seems to work. There must be a universal equation.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Oct 2009
    Posts
    5,418
    Thanks
    718

    Re: Percentage complete

    I believe the last number in the last column in the second table should be 100%, not 1%.

    The correct formula is (C - A) / (B - A) * 100%.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Sep 2011
    Posts
    4

    Re: Percentage complete

    Quote Originally Posted by emakarov View Post
    I believe the last number in the last column in the second table should be 100%, not 1%.

    The correct formula is (C - A) / (B - A) * 100%.
    Excellent, that seems to work for everything I'd tried.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 2
    Last Post: August 26th 2011, 09:19 PM
  2. IS it complete?
    Posted in the Differential Geometry Forum
    Replies: 5
    Last Post: May 24th 2011, 11:47 PM
  3. complete or not ?
    Posted in the Differential Geometry Forum
    Replies: 1
    Last Post: June 3rd 2010, 08:14 AM
  4. Replies: 1
    Last Post: May 9th 2010, 06:32 PM
  5. is this complete ?
    Posted in the Pre-Calculus Forum
    Replies: 6
    Last Post: December 21st 2007, 11:55 AM

Search Tags


/mathhelpforum @mathhelpforum