Tips on using property declaration form
Property declaration formHow to fill it out?
①Regulations on property declaration objects. The objects of declaration generally include public officials from legislative, administrative, judicial, military and other agencies and state-owned enterprises and institutions.
②Regulations on the type and time of property declaration.
③Regulations on the contents of property declaration. It is generally required to write down your movable and immovable property in detail, and indicate the date, value and method of acquisition.
④Regulations on declaration forms.
⑤Regulations on the acceptance, publication and review of declarations.
⑥Regulations on penalties for illegal acts.
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.
Recommended by the editor of Huajun Software Park
property declaration formIt is a very practical form, and most of the forms are for general purposes. If you happen to need a property declaration form, download it quickly. In addition,Graduation Thesis Topic List for Double Degree in Business Administration,Professional Admission FormIt is also a good software. Welcome to click to download and experience it!





















Useful
Useful
Useful