#### How to use Goal Seek in Excel

Goal Seek is a feature in Microsoft Excel that allows you to find the input value that will produce the desired output value in a formula. In this lesson, you will learn how to use Goal Seek in Excel.

## Data preparation

Goal Seek requires you to have a formula in a cell and a desired output value. For example, you might have a formula that calculates the total cost of a purchase, and you want to know how many items you can buy with a budget.

In the example, you know price and budget. You want to check, how many pieces you can buy. In this example, price is \$230 and your budget is \$1 000 000. How many pieces you can afford? Select the cell with the formula (that calculates the result) to be set by Excel for the expected value. In the above example it is a cell with your budget.

## What-if Analysis

To use Goal Seek, go to the Data tab and click the What-If Analysis button. Then, select Goal Seek from the list.

The Goal Seek dialog box will open. In the Set cell field, select the cell that contains the formula. In the To value field, enter the desired output value. In the By changing cell field, select the cell that contains the input value that you want to change.

Click OK to start the Goal Seek process. Excel will adjust the input value in the By changing cell field until the output value in the Set cell field matches the desired value.