Where is goal seek in excel 2011

The screenshots are from Excel Mac and Calc v4. Thanks for the correction. I must have Word trauma. Owen - do we need more information from OP? No, I don't think so.

This appears to be bug back again which is mentioned in the comments of the code I linked upthread. Attachment [details] in that bug is a very clear example, that is once again not working. In that attachment: 1. Select F Plug in "Target value" of 0; Variable cell E7. That was the reported as then working test case, so this may be a regression. Selecting cell F gives the same result.

Reading through the comments in that bug, it does indeed appear to be some nightmare, perhaps related to a limit in the iterations. Thank you for helping us make LibreOffice even better for everyone!

I think the goal seek facility in LO may have a problem, but it would be good to get a comparison with Excel I think this bug can be confirmed. At the very least Calc should offer parity with Excel, in terms of Goal Seek. Status set to NEW. It works perfectly well and find the solution as MS-Excel if you choose the right options for the computation: - solver: use one of the two linear solvers - in Calc options, Calculate tab, uncheck "Precision as shown"; if it is checked, the linear solver says that the problem is not linear.

If you have the non-linear solvers installed, I think they are not suitable to solve other problems than optimization ones minimization or maximization. So it would be useful to know how GoalSeek performs its calculation. Perhaps it could better if GoalSeek did the same computations as the default linear solver.

Best regards. Good point. I don't trust NLPSolver results in v4. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed.

We'd really appreciate your help in getting confirmation that the bug is still present. The formula refers to cells B1 and B2, which contain values that you specified in preceding steps. The formula also refers to cell B3, which is where you will specify that Goal Seek put the interest rate.

The formula divides the value in B3 by 12 because you specified a monthly payment, and the PMT function assumes an annual interest rate. You can ignore that value for now. In the Set cell box, enter the reference for the cell that contains the formula that you want to resolve. In the example, this reference is cell B4.

In the To value box, type the formula result that you want. In the example, this is Note that this number is negative because it represents a payment. In the By changing cell box, enter the reference for the cell that contains the value that you want to adjust.

In the example, this reference is cell B3. Note: The cell that Goal Seek changes must be referenced by the formula in the cell that you specified in the Set cell box. Click OK. Goal Seek runs and produces a result, as shown in the following illustration. On the Home tab, in the Number group, click Percentage. Click Increase Decimal or Decrease Decimal to set the number of decimal places.

If you want to accept more than one input value, for example, both the loan amount and the monthly payment amount for a loan, use the Solver add-in. Finally, format the target cell B3 so that it displays the result as a percentage. Follow one of these steps:. Need more help? Include your email address to get a message when this question is answered. Related wikiHows How to. How to. About This Article. Written by:. Nicole Levine, MFA. Co-authors: 1. Updated: March 29, Categories: Microsoft Excel.

Thanks to all authors for creating a page that has been read 7, times. Is this article up to date? Yes No. Cookies make wikiHow better. By continuing to use our site, you agree to our cookie policy.