Reach a Goal.

[P. Nogueira]

Is it possible to reach a goal in a cell, modifying the values in more than
one cell?

 

[VENKAT]

there is a funcion <goal seek> in tolls menu. This changes one cell if you
change another cell. see help also onthis
is this what you want;.

 

[Jack Schitt]

I think that goalseeker only allows you to modify one variable.
To modify more than one variable use Solver.
Solver add-in is bundled with Excel but needs to be enabled (Tools/addins)

 

[P. Nogueira]

Ok, VENKAT, I know this function, but it permit that I modify only one cell
and I want modify a group of cells. Anyway, thank you for your assistence.

"VENKAT" escreveu:

 

[P. Nogueira]

Thank you Jack. I`m going to try.

"Jack Schitt" escreveu:

 

[VENKAT]

instead of goalseek function use solver. for this you shold click
tolls-addin and see whether <solver addin> is checked. inthat case there
is a funciton<solver> in tools menu. this will be interactive and you can
do some experiments. This takes into account changes in more than in one
cell. I have not used solver except in trivial experiments. see help also.
thanks and regards



On Fri, 22 Oct 2004 18:11:02 -0700, P. Nogueira <P.