Quotation single -table grid template use skills
Single meter tablet templateHow to fill in?
1. Basic information of the seller. Factory logo, company name (Company), Detailed Address, post code, contact name, etc.
2. Basic information of buyers.
3. The presence of the quotation order: quotation/quotation form/price list, reference No. (Reference No.), quotation date (Date), valid date.
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.
3: Multi -condition search
The query department is required to be produced and the name is the minister.
The formula is:
= Lookup (1,0/((b2: b9 = f2)*(C2: C9 = G2)), A2: A9)
The LOOKUP function multi -condition query writing is:
= LOOOKUP (1,0/(((Condition area 1 = condition 1)*(condition area 2 = condition 2), query area)
4: Calculating text calculation
To calculate the text format in the cell, first click the first cell to enter the formula to define the name:
Calculation = Evaluate (C2)
Then enter the formula in the cell:
= Calculate
Xiaobian recommended by Huajun Software Park
Single meter tablet templateIt is a very practical form, and most of the forms are used in common purposes. If you just need to quote the single table template, come and download it. also,Employee Health Management Archives,Owner file tableIt is also a good software, please click to download the experience!
it works
it works
it works