| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
goal seek multiple cells
is it possible to use goal seek on multiple cells?
I want to change a range of values (calculated by formula) , giving the same fixed parameter, by changing the correspondent range of input values. I think I managed to do it once but don't remember how... thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
goal seek multiple cells
Give up on Goal Seek and use Solver : Tools | Solver
Not there? Use Tools | Add-in to add it. Still not there? Stick you office CD in drive; Windows Start | Control Panel | Add/Delete Programs | Go to MS Office and use change; now install Solver Lot of work but a very powerful tool when you get to know it. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "massimo" wrote in message ... is it possible to use goal seek on multiple cells? I want to change a range of values (calculated by formula) , giving the same fixed parameter, by changing the correspondent range of input values. I think I managed to do it once but don't remember how... thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
goal seek multiple cells
"Bernard Liengme" wrote: Give up on Goal Seek and use Solver : Tools | Solver Not there? Use Tools | Add-in to add it. Still not there? Stick you office CD in drive; Windows Start | Control Panel | Add/Delete Programs | Go to MS Office and use change; now install Solver Lot of work but a very powerful tool when you get to know it. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "massimo" wrote in message ... is it possible to use goal seek on multiple cells? I want to change a range of values (calculated by formula) , giving the same fixed parameter, by changing the correspondent range of input values. I think I managed to do it once but don't remember how... thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use goal seek in multiple cells? | Excel Discussion (Misc queries) | |||
| Can I use the Goal Seek function on multiple cells simultanously? | Excel Worksheet Functions | |||
| 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 | |||
Hybrid Mode
