Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek is REALLY annoying me...
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek is REALLY annoying me...
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" 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek is REALLY annoying me...
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek is REALLY annoying me...
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 -- Tibbs ------------------------------------------------------------------------ Tibbs's Profile: http://www.excelforum.com/member.php...o&userid=15947 View this thread: http://www.excelforum.com/showthread...hreadid=547149 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal seek output | Excel Discussion (Misc queries) | |||
goal seek circular reference | Excel Discussion (Misc queries) | |||
Null values in charts and how to override the goal seek functionality | Charts and Charting in Excel | |||
Goal Seek | Excel Worksheet Functions | |||
goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) |