Thread: 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.

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%.

Originally Posted by emakarov

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.