Help with Goal Seek

%3CLINGO-SUB%20id%3D%22lingo-sub-2167613%22%20slang%3D%22en-US%22%3EHelp%20with%20Goal%20Seek%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2167613%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20goal%20seek%20in%20a%20tab%2C%20but%20when%20I%20click%20ok%20an%20error%20message%20pops%20up%20stating%20the%20cell%20must%20contain%20a%20formula.%20Any%20ideas%20on%20how%20to%20remedy%20this%3F%20Noe%20matter%20what%20I%20do%20the%20error%20message%20pops%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2167613%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2167684%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Goal%20Seek%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2167684%22%20slang%3D%22en-US%22%3Ethe%20goal%20seek%20will%20keep%20changing%201%20cell%20until%20the%20value%20in%20the%20other%20cell%20is%20or%20is%20as%20close%20to%20the%20target%20as%20possible.%20But%20there%20has%20to%20be%20a%20formula%20in%20the%20target%20cell%20so%20that%20as%20excel%20changes%20the%20value%20in%20the%20other%20cell%20the%20target%20cell%20value%20will%20change.%20If%20there%20is%20no%20formula%20(that%20must%20somehow%20be%20dependent%20on%20the%20other%20cell)%20then%20it%20doesn't%20matter%20what%20excel%20changes%20the%20other%20cell%20to%2C%20it%20can't%20solve%20the%20problem.%20So%20in%20that%20image%20K13%20needs%20some%20formula%20that%20changes%20based%20on%20the%20value%20put%20into%20K7.%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to create a goal seek in a tab, but when I click ok an error message pops up stating the cell must contain a formula. Any ideas on how to remedy this? Noe matter what I do the error message pops 

1 Reply
the goal seek will keep changing 1 cell until the value in the other cell is or is as close to the target as possible. But there has to be a formula in the target cell so that as excel changes the value in the other cell the target cell value will change. If there is no formula (that must somehow be dependent on the other cell) then it doesn't matter what excel changes the other cell to, it can't solve the problem. So in that image K13 needs some formula that changes based on the value put into K7.