Shulou(Shulou.com)06/01 Report--

Excel planning solution function is what, many novices are not very clear about this, in order to help you solve this problem, the following small series will explain in detail for everyone, there are people who need this to learn, I hope you can gain something.

What I want to share with you today is Excel's planning solution function!

Excel's programming solver is said to be powerful and can solve many linear programming and other optimization problems.

However, the frequency of our daily use of this function has not been very frequent. Today, I will give a small example. Without an in-depth explanation, it is really... I only know the skin ~

Suppose you win 10000 in the raffle (just if), and then you have a lot of things on your shopping list.

What you are thinking about now is how to arrange the purchase quantity of each item so that you can spend exactly 10000 yuan.

You know that you only know the unit price of all the goods you want to buy and the total budget of 10000 yuan. Using excel planning solution can quickly complete your shopping decision.

First, you should list your purchase conditions in detail:

Product name, unit price and purchase quantity, total and final total budget (total price).

Where the product name and unit price are known, you can enter it directly; if the purchase quantity is unknown, you can enter the initial value of 1; the total price should use the function formula (total price = unit price * purchase quantity), and the total price =sum (total price).

In the above data, the formula needs to be used for the total price and total cells, and the initial value of 1 is used for the purchase quantity cell (other values are also possible, in short, there is an initial value).

Open the program solving function in the data menu (if not, your excel has not enabled the add-in macro, go to the history information to view the operation steps).

Target Cell Enter the cell in which the total is located. Set its target value to 10000.

Variable cell set to purchase quantity Cell range (is the dynamic area we want to plan)

The condition fields below are set according to our own actual requirements. Here I set it to an integer greater than or equal to 1. (Click Add directly to set).

Other options default settings.

Finally, choose to solve, the software will solve the optimal purchase decision with a total price equal to 10000 yuan and a purchase quantity greater than or equal to 1 in the purchase quantity cell area, and at the same time, your 10000 is just spent.

Did reading the above help you? If you still want to have further understanding of related knowledge or read more related articles, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.