What-If Analysis - Goal Seek

From excel-easy.com

What if you want to know how many books you need to sell for the highest price, to obtain a total profit of exactly $4700? You can use Excel's Goal Seek feature to find the answer.

1. On the Data tab, click What-If Analysis, Goal Seek.

The Goal Seek dialog box appears.

2. Select cell D10.

3. Click in the 'To value' box and type 4700.

4. Click in the 'By changing cell' box and select cell C4.

5. Click OK.

Result. You need to sell 90% of the books for the highest price to obtain a total profit of exactly $4700.