Step 2: Pop up the [Programming Parameters] dialog box and enter the parameters. Enter the target cell in the target cell text box; Select the [Max \ Min] radio button in the [Equal to] box.

The third step is to set a variable cell range, hold down Ctrl and select it with the mouse, or after selecting each continuous range, enter the comma ",".

Step 4: Click the Add button in the constraint box.

Step 5 Enter constraints in the Add Constraint dialog box that pops up.

Step 6: Click Add to finish adding constraints. Repeat step 5 until all conditions are added.

Step 7 Click [OK] to return to the [Programming Parameters] dialog box, and complete the condition input of the [Programming Parameters] dialog box.

Step 8 Click the "Options" button on the right side of the "Solver Parameters" window. Make sure that the selection box next to Use Linear Model is selected. This is the most important step! If the selection box next to the linear model is not selected, select it and click OK. If all variables are non-negative, and the selection box next to the variable is not selected, please select it and click OK.

Step 9: Click the [Solve] button to open the [Planning Solution Result] dialog box, and the solution result will be displayed in the worksheet.

Step 10 If the result meets the requirements, click [OK] to complete the operation; If the result does not meet the requirements, click Cancel, modify the initial values of cells in the worksheet, and then rerun the Plan Solution process.