Introduction to official seal usage registration form sample form Sample registration form for official seal useHow to fill it out?
The company’s various seals must be kept by dedicated personnel
1. The company’s official seal and special official seal are kept by dedicated personnel in the office, and the official seals of each department are kept by dedicated personnel and counters designated by each department, and the list of personnel who keep the official seals is reported to the office for record.
2. The official seal must be kept in a record, indicating the name of the official seal, the issuing department, the number of pieces, the date of receipt, the date of activation, the recipient, the custodian, the approver, the drawing and other information.
3. Employees are strictly prohibited from taking their official seals out of the company for use without permission. If the official seal needs to be taken out for use due to work needs, an application report must be submitted, approved by the department head, approved by the company's administrative deputy general manager, and reported to the office director for confirmation before it can be taken out.
General tips for using official seal registration form sample
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.
Recommended by the editor of Huajun Software Park
Sample of official seal registration formIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Drug purchase statistics table,Equipment door-to-door service installation income statementDownload to get the source file, which you can edit, modify and replace. To download a sample of the official seal registration form, go to Huajun Software.
it works
it works
it works