Tips for using printed quotations
Printing QuotationPreparation of:
1. Carefully observe the customer's strength and customer printing samples;
2. Carefully measure sample specifications and paper quality and various post-press and pre-press processes;
3. Use a calculator to calculate costs and profits in detail;
4. The quotation uses puns, and the price is not high (meaning it is not higher than the customer's psychological price) and not low (meaning it is not lower than the price of peers);
5. Bargaining refers to negotiating with customers to provide the reasons and basis for quoting prices.
1. Find duplicate content formula: =IF(COUNTIF(A:A,A2)>1, "Duplicate", "").
2. Use the year and month of birth to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).
3. Calculation formula from the birth year and month of the entered 18-digit ID number:
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).
4. To let the system automatically extract the gender from the entered ID number, you can enter the following formula:
=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1."Male", "Female), IF(MOD(MID(C2,17, 1),2)=1,"Male", "Female")) The "C2" in the formula represents the cell where the ID number is entered.
The printed matter quotation form is a very practical form, and most of the fill-in forms are for general purposes. If you happen to need to download the printed matter quotation Excel form, please download it quickly.financial expense budget table,financial planIt is also a good software. Welcome to click to download and experience it!
Useful
Useful
Useful