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 th
cell to alter and typing in the value I'm trying to get to. After
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 m
what value next year's sales need to be for me to achieve my require
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 se
to automatic.

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

Chri

 

[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

 

[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]

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

Chri