Introduction to the seal registration form Seal registration formprocessBesides
1. All the possessions of the company in the name of an enterprise, a letter of introduction, and submitting reports need to be stamped with the corporate legal person seal.
2. Internal texts, notifications, etc., use the company's internal seal.
3. Work documents within the scope of the business of the department, the company, the department and the department, etc., stamped with the seal of the department.
4. For texts such as contracts, agreements and other texts, generally use corporate contracts special seal or corporate legal person seal.
5. Anyone who belongs to the financial accounting business, uses a special chapter of finance.
Great Skills of the Registration Form for Seal
1: Multi -condition count
Requirements: The number of people who are produced by the statistical and statistical departments and are mainly operated by their posts
The formula is:
= Countifs (B2: B9, F2, C2: C9, G2)
In the statistical condition area of the Countifs function, the number of cells that meet multiple specified conditions. The conventional usage is:
= Countifs (Condition area 1, specified condition 1, condition area 2, specified condition 2 ...)
2: Condition search
The VLOOKUP function has always been the existence of Volkswagen's lover. The syntax of the function is:
Vlookup (Who wants to find, where to find, return the content of the first column, find it precisely or approximate)
To check what positions of the employee name in the F5 cell.
= Vlookup ($ F $ 5, $ B $ 1: $ D $ 10, 2,0)
When using this function, you need to pay attention to the following points:
1. The 4th parameter is generally found in accurate matching by 0 (or fasle).
2. The column number in the 3rd parameter cannot be understood as the actual column number in the worksheet, but the specified column of the return value in the search range.
3. If the data type of the finding value is inconsistent with the data type of the data area, the error value will be returned.
4. The search value must be located in the first column in the query area.
Xiaobian recommended by Huajun Software Park
Seal registration formFor free Excel templates, download it if you need it! Huajun Software Park provides a boutique Excel template download.Application form for construction project funds,The main financial status table of construction enterprisesYou can get the source file for you to edit and modify and replace it. Download the seal registration form to the Huajun Software Park.
it works
it works
it works