What purpose does Goal Seek Solve?

Asked By 0 points N/A Posted on -
qa-featured

Its related to  MS Excel when any one is looking for answers to what-if questions.

SHARE
Answered By 0 points N/A #161100

What purpose does Goal Seek Solve?

qa-featured

It is related to find out the result of a formula would be if  only one variable is to be changed in Ms excel.  When we know the desired result of a single formula but not the input value the formula needs to determine the result, we can use the Goal Seek feature.
Ms excel varies the value in one specific cell until a formula that's dependent on the cell returns the result we want.

FINDING VALUE USING GOAL SEEK

  • Select the cell,having formula,having value to be edited.
  • Choose Alt+TG
  • Click in To Value text box, and type in the new value
  • Click the By changing cell box, and type cell address of cell whose relative value is to be changed.
  • click OK.
  • Goal Seek Status dialog box appears, giving the result
  • Click on Ok to change the value and cancel to ignore the result.

Login/Register to Answer

Related Questions