Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i apply Goal Seek to a range of cells in Excel
I need to apply a Goal Seek result to a range of cells. i get the error
message ''Reference must be to a Single Cell" How can i get around this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i apply Goal Seek to a range of cells in Excel
Excel is doing what it is supposed to do. Goal Seek works on a single cell.
Solver, however, can be used to change a range of cells. Check this out: http://www.informit.com/content/imag...0789729539.pdf This is good too: http://office.microsoft.com/en-us/ex...118641033.aspx One mo http://ezinearticles.com/?Tools-From...ver&id=1107843 If you feel really ambitious, read this: www.decisioneering.com/index.html Regards, Ryan-- -- RyGuy "Mabvuto" wrote: I need to apply a Goal Seek result to a range of cells. i get the error message ''Reference must be to a Single Cell" How can i get around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
goal seek multiple cells | Excel Worksheet Functions | |||
how to use goal seek in multiple cells? | Excel Discussion (Misc queries) | |||
How can I use Goal Seek in multiple cells? | Excel Worksheet Functions | |||
Goal seek multiple cells | Excel Worksheet Functions | |||
Goal Seek on Multiple Cells | Excel Worksheet Functions |