Topic 38: How to Use Goal Seek in Excel? (Real-Life Example Demnstrations)

[seema]

Goal Seek (Text) - An Example

Say you wish to purchase a car, your current vehicle is worth $4,000 in part exchange. This part exchange value plus your cash down payment of $1000 makes up the 20% deposit required towards the cost of the new car. A spreadsheet to show this is illustrated and shows that you can afford a new car costing $25,000. The only formula in the spreadsheet is in cell E4:
=(E2+E3)*5

Suppose that you have seen a car costing $ 30,000 your question would likely be. What will my cash down payment now need to be? You could experiment by entering various values into the Down Payment cell or you could use Goal Seek.

• Make cell E4 (i.e. the total car price that you can afford) your active cell by clicking on this cell.
• Start Goal Seek by opening the Tools menu and click Goal Seek.
• Enter 30000 in the To value text dialog box and then press the Tab key to move to the field in the Goal Seek dialog box called By changing cell
• 
  
  
• Use the mouse to click on the cell E2. This means that when click on the OK ****on, the contents of this cell will change to fit in with our desired result.
• Click OK. The Goal Seek Status dialog box is displayed and the value of your Down Payment has changed to $2000. This is the new amount you should have pay to obtain this car.
• 
  
  
• If you click OK these changes are accepted or if you click Cancel these changes are not accepted.

Similar Threads:

• Amit Verma's reel and real life mix-up...
• Sushant’s real life and reel life partner similar
• Harsh Chhaya's real life mid-air escapade!
• Real-life Bollywood romances: 2008
• Shahid is all set to portray his real life passion for....

[seema]

Goal Seek (Graphical) - An Example

If we suppose that you have seen a car costing $14,000 your question would likely be. What will my cash down payment now need to be?

• First select the data as illustrated.
  
  
• Click on the Chart Wizard icon on the Standard toolbar and when the Chart Wizard dialog box is displayed, click on the Finish ****on to create a bar chart using default formats.
  
  

[seema]

• The bar chart produced should resemble that shown below.
• 
  
  
• Click once on the column representing the Total car price that you can afford. You will see a small rectangular square in the center of each column as illustrated.
• 
  
  

[seema]

• Click once on this column again, and the display will change as illustrated.
  
  

• Move the mouse pointer to the top of this column and then click and drag the column up or down as required. You will see a small rectangular box is displayed, which indicates the value that you have dragged to.
• In our example, we dragged to $ 14,000.00 only that release the mouse.
• 
  
  
• The Goal Seek dialog box appears ready for you to enter a cell reference into the By changing cell: text box.
• Click on the cell E2, to place this value into the By changing cell: text box.
  
  
• Click on the OK ****on to display the Goal Seek Status dialog box.
• 
  
  
• Click on the OK ****on to accept these changes and exit from the Goal Seek Status dialog box.