Goal Seek is REALLY annoying me...

[Tibbs]

Hi all,

I'm using Goal Seek for the first time in ages.

I'm selecting the cell I whose value I want to change, choosing the cell to alter and typing in the value I'm trying to get to. After a microsecond of thinking it tells me that it's found the right answer, but it doesn't put the answer in the cell! All it's doing is telling me what value next year's sales need to be for me to achieve my required growth - it's not rocket science or anything!

I'm using Excel 2003 (11.8012.6568) SP2

Is there something really obvious I'm not doing? I have calculation set to automatic.

Please help, before I beat my computer with something solid...

Chris

[Mike Middleton]

Chris or Tibbs -

When goal seek finds a solution, in the Goal Seek Status dialog box, if you
click OK, the "solution" value appears on the worksheet, but if you click
Cancel, the original values are restored.

- Mike
www.mikemiddleton.com

"Tibbs" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> I'm using Goal Seek for the first time in ages.
>
> I'm selecting the cell I whose value I want to change, choosing the
> cell to alter and typing in the value I'm trying to get to. After a
> microsecond of thinking it tells me that it's found the right answer,
> but it doesn't put the answer in the cell! All it's doing is telling me
> what value next year's sales need to be for me to achieve my required
> growth - it's not rocket science or anything!
>
> I'm using Excel 2003 (11.8012.6568) SP2
>
> Is there something really obvious I'm not doing? I have calculation set
> to automatic.
>
> Please help, before I beat my computer with something solid...
>
> Chris
>
>
> --
> Tibbs
> ------------------------------------------------------------------------
> Tibbs's Profile:
> http://www.excelforum.com/member.php...o&userid=15947
> View this thread: http://www.excelforum.com/showthread...hreadid=547149
>

[Daniel CHEN]

I am not quite sure the way you used Goal Seek is right or not (no offend):

Cell 1 - I'm selecting the cell I whose value I want to equals to the target
value
Cell 2 - choosing the cell to alter
Target - typing in the value I'm trying to get to.

Once the calculation is complete and a message box pop up, you click OK
button,
Your Cell 1 should the target value, and Cell 2 should have the value which
makes cell 1 have target value.

Try this:
Input 1 to Cell A1
Type formula =A1^2 in Cell A2.

Set up goal seek:
Set Cell: A2
To Value: 10
By Chaning Cell A1

Once the goal seek completes, you should have 3.16 in cell A1 and 10 in Cell
A2.



--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Tibbs" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> I'm using Goal Seek for the first time in ages.
>
> I'm selecting the cell I whose value I want to change, choosing the
> cell to alter and typing in the value I'm trying to get to. After a
> microsecond of thinking it tells me that it's found the right answer,
> but it doesn't put the answer in the cell! All it's doing is telling me
> what value next year's sales need to be for me to achieve my required
> growth - it's not rocket science or anything!
>
> I'm using Excel 2003 (11.8012.6568) SP2
>
> Is there something really obvious I'm not doing? I have calculation set
> to automatic.
>
> Please help, before I beat my computer with something solid...
>
> Chris
>
>
> --
> Tibbs
> ------------------------------------------------------------------------
> Tibbs's Profile:
> http://www.excelforum.com/member.php...o&userid=15947
> View this thread: http://www.excelforum.com/showthread...hreadid=547149
>

[Tibbs]

Thanks for the help, guys, the example set worked, and doing it exactly the same way on my problem didn't... Who knows! Still, did it another way and got the result I needed.

Chris