Using Goal Seek

Intellezy Trainers
A free video tutorial from Intellezy Trainers
Computer Training Specialists
4.4 instructor rating • 227 courses • 150,085 students

Learn more from the full course

Excel 2016 Advanced

Take Excel to the next level with advanced formulas, What-If Analysis tools, advanced PivotTables, Macros and much more

02:18:13 of on-demand video • Updated April 2018

  • Use Advanced IF Statements
  • Use Advanced Lookup Functions
  • Use Complex Logical and Text Functions
  • Auditing Formulas
  • Working with What-If Analysis Tools
  • Protecting Worksheet and Workbook
  • Use Advanced PivotTables and PowerPivot Tools
  • Automate with Macros
  • Work with Form Controls
  • Ensure Data Integrity
  • Collaborate in Excel
  • Import and Export Data to a Text File
English -: There may be times when you want the result of your formula to be something specific. For example, my total available over here, let's say that I, in summing these things up here, and let's say that I want to set my total available equal to let's say 85,0000. We'll do a different number, let's say 87,500. And I want to see automatically what my operations budget could be if my total available changed to that. Well, I can use Goal Seek to do that. Goal Seek allows me to set the results of a formula to whatever I choose, by adjusting one of the cells the formula is based on. So let's take a look. I'm going to click on the cell. It has to be the cell with the formula in it, all right? That's the only way Goal Seek will work. I'm going to go to data. I'm going to go to what-if analysis. And I'm going to choose Goal Seek. Three easy things here. Set cell, this is going to be the cell that has the formula. To value, this is going to be what I want it to set that formula result to be. So I'm going to do 87,500. My changing cell, B10. Has to be one of the cells that the formula is based on. I'm going to click okay. And there we go. Does my calculation for me. So I'm very easily able to set the results of my formula to whatever I want by adjusting one of the cells that the formula is based on.