What if analysis worksheet

We have to get the percentages in each combination. In these situations, the Data table will help to find the output for a different combination of inputs. Now we will see how to achieve this. First, create a formula to perform this. If we observe the above screenshot, the part marked with a box is the example. In A3, we have the formula to find the percentage from A1 and A2. So inputs are A1 and A2. Now take the result of A3 to A1 as shown in the below screenshot. Now select the entire table to apply the Data table of What if Analysis as shown in the below screenshot.

This is a guide on What if Analysis in Excel. Here we discuss three different tools in What if Analysis and the examples and downloadable excel template. You may also look at the following articles to learn more —. Submit Next Question. For more information on scenarios, check out this article from Microsoft. For more information on data tables, check out this article from Microsoft. Function calculating the monthly payment. Selecting cell B7. Selecting Goal Seek from the drop-down menu.

Entering the desired values into the dialog box and clicking OK. Clicking OK. The completed Goal Seek and calculated value. The Financial command. Selecting the PMT function. Entering values into the necessary fields.

In the completed 5 exams, the anticipated scores are as below. Now the question is how much he has to score in the final exam to get an overall average of 85 eventually. The next and final part is by changing which cell you want to see the impact. Now we have our results here. In order to get an overall average of 85, Andrew has to score 99 in the final exam.

We have already seen two wonderful techniques under What-If Analysis in Excel. The data table can create different scenario tables based on the change of variable. In simple terms, it helps determine what effect does changing the two variables have on the result. The data inputs in one variable data table are either in a single column or across a row. Assume you are a selling a product at 15 rupees, your total anticipated expense is and profit is You are not happy with the profit you are getting.

Your anticipated profit is So we have our data table ready. If you want to make a profit from , you need to sell at 20 per unit. Chapter What-If Analysis. Download Excel File what-if-analysis. Next Chapter Solver. Follow Excel Easy.