If A is 9, what will be the second number for B to get the result, 72. Make sure to download the attached file to work with this example in Excel.In the above figure, there are two numbers, A and B, with the value of 9 and 6, respectively.Ī product is done using the function =PRODUCT(B1,B2), resulting to 54. I recommend trying Goal Seek to solve your problems first and, if that doesn't work, then try Solver. Solver is a lot more powerful than Goal Seek, albeit more difficult to use, and is great for iterating through problems in Excel. In many simple cases, Goal Seek will work just fine, but, Goal Seek often can't find the exact answer for more complex problems in that case, you will need to use Solver. We now know that it will take a selling price of $13.32 in order to get a 25% margin in this case. The next window will give some information on the solution it found and you can just hit OK to go to the spreadsheet.
You click in the input fields and then select the desired cells on the spreadsheet, but you must type in the value for the To value input.25, which is 25% in decimal form.īy changing cell: this is the cell that Goal Seek will change in order to get the desired value in the Set cell. To value: this is the value that we want the Set cell to be equal to. In our example, this is the Margin cell, B4, because that is the cell that we want to contain the value of 25%.
Set cell: is the cell that contains the end result that we want to get. In the window that opens, we need to fill-in 3 inputs.Go to the Data tab and click What-If Analysis and then Goal Seek.(To calculate 17%, cell B4 contains a simple formula in it so it will update when you change cell B1 or B2.) How to use Goal Seek
However, we want a 25% margin, so, what selling price do we need in order to get a 25% profit margin? You can see in the example that a $12 price gets us a 17% profit margin. In this example we have a product that cost us $10 and currently a selling price of $12. Goal Seek is used because it is easier and often more convenient. Note: there are limitations to using Goal Seek and sometimes you will need to use Solver instead. Using Goal Seek, you setup a formula or a series of formulas in a worksheet and have Excel cycle through different input values until it finds the one that generates the result that you wanted. Find a desired result by having Excel automatically change input values in Excel.
0 kommentar(er)
