What-if Analysis Goal Seek
By: Emma Ezzell
What-If Analysis Goal Seek
You can use the what-if analysis goal seek to find what amount you need to get to a desired cell amount. First you go to the toolbar and click on data and then you can go in that toolbar and click on the what-if analysis on the far right. Once you click on the what-if analysis three things will come down, but you want to click on goal seek.
Using Goal Seek
Once you have clicked on goal seek something will pop up like this picture to the right. You will then click on the cell with the value that you want to use as your starting amount for "set cell". Then you can put in for "to value" the desired amount you want it to be. Then for "by changing cell" you put the cell you want it to show up in.
What Happens When You Use Goal Seek
When you push "ok" it will then set the desired cell to the amount it needs to be