To value – This is the value that you need the set cell amount to change to.Set cell – This is the cell that has the amount which we need to find out.The Goal Seel Formula comprises of three arguments, namely : Similarly, any required amount to reach a certain goal can be calculated easily using the goal seek excel online. It can easily be used for back calculations as well.įor example – You can set your net profit’s required amount to 0 in the Excel goal seek formula to find out the number of sales you have to generate to reach the breakeven point. In a matter of seconds, it can find out the exact answer that would have taken a long time to find out manually. If you have a formula and want to show a specific result, but you do not know what input values to change within the formula, then Excel Goal Seek Formula is the one for you.Įxcel Goal seek formula is an excellent way to minimize the efforts required in testing out a hit and trial method of finding answers.
