(1) Calculating rules stipulated in the volume of the project quantity list;
(2) The consumption quota released by the government uniformly;
(3) Refer to the enterprise quota when the enterprise quotes the independent offer;
(4) Workers, materials, machine market prices and enterprises that affect the relationship between the market's supply and demand relationship and the profit and management fee standard determined by the enterprise.
1: IF function condition judgment
The if function is one of the most commonly used judgment class functions, which can complete the judgment of this or the other.
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.
Engineering budget quotationFor free Excel templates, download it if you need it! Huajun Software Park provides a boutique Excel template download.Personnel Health Declaration Form,Product adjustment application formDownload you can get the source file for you to edit and modify and replace it. The download project budget quotation will go to Huajun Software Park.
it works
it works
it works