project management plan

List of project management plan contents:

1. Work plan
2. Personnel organization plan
3. Equipment procurement and supply plan
4. Other resource supply plans
5. Change control plan
6. Progress plan
7. Cost investment plan

​ ​ 1: IF function conditional judgment
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
​ ​ 2: Multi-condition judgment
If the department is production and the position is mainly for operations, there is a high temperature subsidy. Use the formula in column D:
=IF(AND(B2="Production",C2="Main Operator"),"Yes","No")
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
​ ​ 4: SUMIF usage is:
=SUMIF(condition area, specified summation condition, summation area)
In layman’s terms, it can be described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, sum the corresponding area of the C2:C5 cell.

      project management planIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Time deposit details,Final accountsDownload to get the source file, which you can edit, modify and replace. Download the project management plan and go to Huajun Software Park.