# Percentage complete

• Sep 4th 2011, 08:58 AM
Echilon
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.
• Sep 4th 2011, 10:26 AM
emakarov
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%.
• Sep 4th 2011, 10:48 AM
Echilon
Re: Percentage complete
Quote:

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. (Clapping)