Goal Seek is part of a suite of commands sometimes called what-if analysis tools. When you know the desired result of a single formula but not the input value the formula needs to determine the result, you can use the Goal Seek feature.
When goal seeking Microsoft Excel varies the value in one specific cell until a formula that's dependent on that cell returns the result you want. In this tutorial we look at how it can be used to work out break even point in a business plan.
|
