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" wrote in
message ...
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