wheoo.blogg.se

When you click ok, the goal seek function will update the Round 4 score that the player needs in order to achieve an average of 85.

“Set cell” – This will be the Average cell, Cell C9.īy changing cell” – This will the Round 4 score, Cell C8. Let’s use the Goal Seek function to find out, how much the player needs to score in round 4 to achieve the target average score of 85. His average score stands at 81 at the end of round 3, but he needs to have an average score of 85, in order to proceed to the next level. The table below shows a player’s scores in his first 3 rounds of a game. of Units that needs to be sold, in order to achieve a revenue of $100,000 and will update the No of Units cell once it finds the solution. Step 2 – When the OK button is clicked, goal seek function will try to find the No. In this example, this will be No of Units sold.

In this example, “To Value” will be 100,000.īy changing cell – This is the input cell what will be changed to get the value we seek. To value – This is the output/result we expect in the formula cell. In this example, this will be the Target Annual Revenue cell(Cell D6). Set cell – This is the formula cell or the output cell.