Calculate a percent distribution you can use a formula that simply divides an amount by the total. We have calculated percentage of project completion in excel using a simple formula. The general formula for evaluating the percentage change between two numbers is.
For this example the formula you would use is A1 1-B1.
Dont forget always start a formula with an equal sign. In the example shown the formula in D6 is. The change is usually a difference between the two values in context. PartTotal100 Lets do this in excel.