DETERMINE PERCENTAGE OF COMPLETION USING MICROSOFT EXCEL

To manage a project it is necessary to determine the percentage of completion. This can be accomplished with the following calculation.

To calculate percentage of completion:

1. In a worksheet, enter data in columns A, B, and D as shown in Figure 1-20, or use your own data.
2. Select cell E2 and type =B2+B3.
3. Select cell E3 and enter the target value of 200.
4. In cell E5, type the formula =E3-E2 to get the difference between the target and the number already produced.
5. Calculate the percentage of missing products in cell E6 with this formula: =1-E2/E3.
6. Select cell E8 and calculate the percentage of production by using this formula: =100%-E6.

DETERMINE PERCENTAGE OF COMPLETION USING MICROSOFT EXCEL

Microsoft Excel Tutorials, Determine Percentage of Completion using Excel, Basic Tutorials of Excel, Microsoft Excel Video Tutorials, Macros & Visual Basic Usage