Tips for using sales work plan template
Sales work plan templateHow to fill it out?
1. Combined with the company’s production situation;
2. Combined with market demand;
3. Combined with the competition situation of the market;
4. Combined with the realization of the previous sales plan;
5. Combined with the construction of the sales team;
6. Combined with competitors’ sales.
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)
Recommended by the editor of Huajun Software Park
Sales work schedule templateIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download a sales work plan template, download it quickly. also,Construction project quality acceptance form,Recruitment performance summary tableIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works