Data: Goal Seek Options
3. What Do You See? The Goal Seek Status
shows the Target Value of 12000. The Current Value in Cell E25 is
set to $12,000.
What Else
Do You See? The
Price in Cell B1 changed from $3.25 to 4.355717. This is the new
Price you need to reach the goal of $12,000 in sales. If you click
OK, the new Price in Cell B1 will be kept.
Do
This, Please: Click CANCEL to undo the changes made by
the Goal Seek.
Memo to Self: The Price in
Cell B1 looks odd with all the decimal places. You can format Cell
B1 for currency if you wish.