How do you use Goal Seek with two variables?

Here’s how to use Goal Seek, step by step:

1. Click Data > What-If Analysis > Goal Seek.
2. Put the “equals” part of your equation in the Set Cell field.
3. Type your goal value into the To value field.
4. Tell Excel which variable to solve for in the By changing cell field.
5. Hit OK to solve for your goal.

Can you set more than one variable cell in Goal Seek?

Thanks! – Goal Seek option do not support more than 1 cell values for it’s calculation. If you really need it then you need to show your sample data, and need to do it through formulas.

How does Goal Seek work in Excel 2010?

How to Use Excel 2010’s Goal Seek Feature

1. 2On the Data tab, choose What-If Analysis→Goal Seek in the Data Tools group. This action opens the Goal Seek dialog box.
2. 3Select the To Value text box and enter the goal.
3. 5Click OK.
4. 6If you want to keep the values entered in the worksheet as a result of goal seeking, click OK.

Will Goal Seek allow you to test multiple inputs?

Goal Seek can process only one input value at a time. If you are working on an advanced business model with multiple input values, use the Solver add-in to find the optimal solution.

What is the formula for goal seek in Excel?

How to use Goal Seek feature in Microsoft Excel Step 1: Create a new or blank worksheet. Step 2: Type the given formula in cell B4 =PMT(B3/12,B2,B1) to calculate the instalment amount against the loan. Step 3: Select the cell B4 and click on the Data tab > Click on the What-If-Analysis command > Click on the “Goal Seek” option.

What is the formula for goal seek?

Whenever you use Goal Seek, you’ll need to select a cell that already contains a formula or function. In our example, we’ll select cell B7 because it contains the formula =AVERAGE(B2:B6). From the Data tab, click the What-If Analysis command, then select Goal Seek from the drop-down menu.

What is the goal seek function in Excel?

1) On the Data tab, in the Data Tools group, click What-If Analysis, and then click Goal Seek . 2) 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. 3) In the To value box, type the formula result that you want. In the example, this is -900. Note that this number is negative because it represents a payment. 4) 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. 5) Click OK .Goal Seek runs and produces a result, as shown in the following illustration. See More…

What is Go Seek in Excel?

Goal Seek is Excel’s built-in What-If Analysis tool that shows how one value in a formula impacts another. More precisely, it determines what value you should enter in an input cell to get the desired result in a formula cell. The best thing about Excel Goal Seek is that it performs all calculations behind the scenes,…