![how to use goal seek excel 2013 how to use goal seek excel 2013](https://cdn.ablebits.com/_img-blog/goal-seek/goal-seek-profit-parameters.png)
![how to use goal seek excel 2013 how to use goal seek excel 2013](http://i1.ytimg.com/vi/f6c93-fQlCs/maxresdefault.jpg)
To do this job select the the cell F2 and open Goal Seek feature from Data Tab > What-if-Analysis > Goal Seek…. In that situation you have to use Goal Seek feature to get the March’17 detail which match the final required average sales. Step 3: In H column you will get party-wise final required average sales but March’17 detail is missing. Copy the formula to rest of the cell either from fill handle or from copy and paste command. Step 2: Calculate the average sales amount by typing the following given formula in cell F2 =AVERAGE(C2:E2). Must Read: Using PPMT Function Creating a Mortgage Calculator in Excel Step 1: Create the following worksheet to watch the beauty of Goal seek feature in Excel to find the answer. In that situation if you want to get the exact answer of your query then you must have to use Goal seek feature in Excel.
#How to use goal seek excel 2013 how to
Now you have an query how to use Goal seek feature to calculate the third month party-wise sales amount which match the given avg sales.īeauty of Goal Seek feature in Excel to Find the Answer Top management share party-wise three month required average sales value. Now you want to calculate the avg sales amount but third month value is still missing. You can not create the one input data table but also create two input data table in MS Excel.įor eg: If you have a large worksheet in which you have different columns like party-name, town and two month sales amount. Data tables also an important part of What-If-Analysis. Goal Seek feature allows you to change single variable value while solver allows you to change more than one variable values and view the impact for others. You can change single value and view the impact on the resulted value. It is an important part of What-If-analysis. Goal Seek is used to change the single value and view the impact for other values. In this guide we have to discuss about the beauty of Goal Seek feature in Excel to find the answer of your query. What-if-Analysis has four important parts – Goal Seek, Solver, Data Table and Scenario Manager. What-if-Analysis is a process which allows you to changing the values in the given cells and watch the effect on resulted value cell. What if Analysis is an important tool of Excel. There are lot of interesting and useful feature of Excel which allows you to solve complex calculations. In that situation you must have to use Goal Seek feature in Excel sheet to find the answer of your query. Must Read: How to Age calculation From Date of Birth – MS EXCEL If you have more than one variable values and you want to change the final result value but want to apply effect only for one cell. There are lot of situation in which you can use Goal Seek feature during preparing different kind of reports. Goal Seek is the best tool used to find the result by adjusting an input value. it is an important feature of Excel which allows you how to one value in the formula impacts to other cell value. Goal Seek feature in Excel is an important part of What-If-Analysis.