What is Goal Seek in Excel
The Goal Seek in Excel is a built-in What-if-Analysis tool that helps us to know how one value in a formula impacts another. It also determines what should be given as input to attain the desired output. The Goal Seek tool is especially useful for doing sensitivity analysis. It has many uses.
How to use Goal Seek in Excel for What-If analysis with Examples
Goal Seek is a “What if – analysis” tool available in MS EXCEL to determine or calculate any input value based on the formula and the output/resultant value. In simple language, we can say, “What should be the input value of the given output”? The good thing about Goal Seek is that it performs all calculations behind the scenes. You are only asked to give these three parameters Set cell, To value, By changing cell.
Contact Us