G
Guest
Is it possible to reach a goal in a cell, modifying the values in more than
one cell?
one cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
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;.
change another cell. see help also onthis
is this what you want;.
J
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)
To modify more than one variable use Solver.
Solver add-in is bundled with Excel but needs to be enabled (Tools/addins)
G
Guest
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:
and I want modify a group of cells. Anyway, thank you for your assistence.
"VENKAT" escreveu:
G
Guest
Thank you Jack. I`m going to try.
"Jack Schitt" escreveu:
"Jack Schitt" escreveu:
V
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.
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.