1. ## 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.

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

3. ## Re: Percentage complete

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.