Observation approval formHow to fill in?
There are two types of employee resignation:
1) Employees take the initiative to leave, that is, employees will unilaterally submit an application for resignation from the enterprise;
2) Enterprises have proposed to terminate the labor relations between the two parties because of their uncomfortable positions, unqualified trials or serious violations of corporate rules and regulations.
The criteria for assessment scores are 9 points, and it is necessary to determine whether the assessment scores of column B are qualified.
= If (B4> = 9, "Qualification", "Unqualified")
2: Multi -conditional judgment
If the department has high temperature subsidies for production and positions. Use formula in column D:
= If (and (b2 = "production", c2 = "main operation"), "Yes", "None")
3: Conditions Seeking peace
Calculate the total score of a class with the Sumif function:
= Sumif (D2: D5, F2, C2: C5)
4: Sumif usage is:
= SUMIF (conditional area, specified peaceful condition, the area where peace is required)
The description is described in popular words:
If the class in the D5 area is equal to the "one class" of the F2 cells, the region of C2: C5 C5 is required to sum up.
Observation approval formIt is a very practical form, and most of the forms of the form are commonly used. If you just need to leave the approval form to download, come and download it. also,Call customer registration form,Property Management Owner Information Registration FormIt is also a good table template, please click to download the experience.
it works
it works
it works