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?

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?