Data: What If? Goal Seek
Here are the steps to try a Goal Seek.
1: Try It: Select the Goal
Go to the Pigs spreadsheet.
Select: Cell E25.
Go to
Data ->
Data Tools->What-If Analysis.
Click on
Goal Seek.
2. Try
This: Define the Options
You will
be prompted to fill in the blanks:
Set
cell: E25 (the SUM of the sales).
To
value: 12000 (the Goal you want to make).
By
changing cell: $B$1 (the Price)
Click
OK...keep going.