So we will select cells from B2 to B6 and should be >= to zero. Step 7- Now for the third condition, we want that our item quantity should never be un negative which is not possible in real life. So in cell reference, we will select from B2 to B6 then int, and then again will press Add. Step 6: For the second condition we will select the Quantity cell because we want the quantity to be an integer value, a whole value. So we will select cell D7 in a cell reference and then = sign, and finally, we will select cell C11. The first condition is that the total amount should be equal to the voucher amount. Step 5– Now, a dialog box will appear and we will add 3 conditions. So for setting some conditions /constraints, we will click on Add. Step 4: Now we have to set some conditions under which we want our work to get done. Step 3: Now in the ‘By changing Variable cell’ we will select the Quantity cell because we want to change the quantity in such a way so that the total amount comes to 10,000. After clicking on D7 following thing will be displayed on the set objective block. Step 2: In the set objective we have to select the total of the D column because want the value to change from 9300 to 10,000. Now in this, we have to select the objective in which we want to change our value. Step 1: Firstly go on data and find solver there and click it. So now we want to use Solver for this purpose. Suppose we purchased the above items in only one quantity and the total came out to be 9300 but the voucher was for rs.10,000. So, suppose we purchased the following items. We went to a mall and we also have a gift voucher worth rs.10,000 and We want to purchase items in such a manner that all the money of the gift voucher gets utilized.
Excel solver examples business model how to#
Now let’s understand how to use solver with the help of an example.
Step 4: Now solver will appear in data section like this.
Step 3: After clicking OK, Select Solver Add-in and press OK. Step 2: Now select the Add-ins option and click on Go and finally click on OK. For activating the solver tool we need to do the following steps: Solver is present in MS- Excel but for using it we need to activate it.
ISRO CS Syllabus for Scientist/Engineer Exam.ISRO CS Original Papers and Official Keys.GATE CS Original Papers and Official Keys.
0 kommentar(er)
