1 Commodity plan;
2 channel plan;
3 cost plan;
4 Sales Unit Organization Plan;
5 5 sales plan;
6 Promotion Promotion Plan;
7 Promotion plan.
1: IF function condition judgment
The if function is one of the most commonly used judgment class functions, which can complete the judgment of this or the other.
The criteria for assessment scores are 9 points, and it is necessary to determine whether the assessment scores of column B are qualified.
= If (B4> = 9, "Qualification", "Unqualified")
2: Multi -conditional judgment
If the department has high temperature subsidies for production and positions. Use formula in column D:
= If (and (b2 = "production", c2 = "main operation"), "Yes", "None")
Month Sales Planning FormFor free Excel templates, download it if you need it! Huajun Software Park provides a boutique Excel template download.Modernization office equipment list,Teaching progress tableDownload you can get the source file for you to edit and modify and replace it. Download the monthly sales plan to the Huajun Software Park.
it works
it works
it works