Moreover, the Solver can account for any problem constraints, whereas Goal Seek Excel cannot handle any constraints. Excel Solver is a powerful method to solve optimization problem. The Goal Seek feature in Excel solves for a single input cell to achieve the desired objective, whereas the Excel Solver can solve for various input cells to achieve the desired. If you have a complex problem which contains multiple equations and multiple constraints and you are asked to find the optimal solution, you should look for Excel's Solver Add-In instead of Goal Seek.

As shown in the second case study, it takes time to transform equation of loan payment and calculate the terms without using Goal Seek.

It saves a lot of time when it is difficult to derive a formula to calculate unknown value. Goal Seek is very helpful for quickly solving any financial and statistical formula for a single unknown value. Solution : Goal Seek found the solution and it is required to pay 50 monthly payments when $4000 is paid monthly in installment.

In By changing cell:, give cell reference of C4 ( Refer figure 2).

It is important to remember that Excel will stop trying to find. Make sure it is negative since it is a payment. You can build complex worksheet models and then employ the Goal Seek feature to derive. If we assume the cell C6 contains the desired goal value. You can set a value for this cell - instead of a static value - to run the Goal Seek for the cell value. Our examples have had a static number for the Goal argument in the previous examples.

In Set cell:, enter reference of cell C6. Range('C6').GoalSeek Goal:39, ChangingCell:Range('C4') End If End Sub.

Go to Data tab and then click on What-If Analysis and select Goal Seek.

Since C5 is annual interest rate, we need to divide it by 12 Enter formula =PMT(C5/12,C4,C3) in cell C6 (Refer the image above).of Payments (Monthly) and Annual Interest Rate from cell C3 through C5.

Goal seek on excel for mac