The monitoring of quotations is mainly used for quotations from suppliers to customers, similar to price lists. The seller offered a viable price by considering the cost of its own product, profits, market competitiveness, etc. The source file is in xlsx format, so you can edit your own content styles by downloading the source file, and you can ask for more free downloads of the control quotation。
Controlling the application of quotations
How do you fill out the surveillance quotations
01, vendor basic information (example)
Factory logo
Company
Detailed address(detailed address)
Post code
Contact (contact)
Job title
Telephone number (telephone no
Fax number (fax no.)
Mobile no
02, buyer's basic information (example)
Factory logo
Company
Detailed address(detailed address)
Post code
Contact (contact)
Job title
Telephone number (telephone no
Fax number (fax no.)
Mobile no
03, heads of quotations:
Quoting/quoting form/ price list
Reference no
Date of quotation (date)
Valid date
Monitor the general technique for quotations: 1: if function condition judgement
The if function is one of the most common type of judgement functions that completes the judgement。
The test score is a score of 9 to determine whether the b score is satisfactory。
=if
2: multi-conditional judgement
If the department is responsible for production, the job is major, there's a heat subsidy. Use formula in column d:
== sync, corrected by elderman == @elder man
3: consistency
Use the sumif function to calculate the total achievement of a class:
=sumif(d2:d5,f2,c2:c5)
4: sumif used:
= sumif (conditional area, specified sum, sum area)
It's in a popular way:
If the class in the d2:d5 area is equal to the " one class " of the f2 cell, the sum of the c2:c5 cell corresponds。
It's recommended by chinese army software park
The monitoring of quotations is a very practical form, and most of the filling out of the forms is for general use, and if you happen to need it, download it. In addition, the swot analysis and the kindergarten morning check-ups are good software
