Reach a Goal.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

P. Nogueira - 17 Oct 2004 01:45 GMT

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

Reply to this Message

VENKAT - 17 Oct 2004 04:59 GMT

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;.
------------

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

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Reply to this Message

P. Nogueira - 23 Oct 2004 02:11 GMT

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.

> there is a funcion <goal seek> in tolls menu. This changes one cell if you
> change another cell. see help also onthis
[quoted text clipped - 4 lines]
> > than
> > one cell?

Reply to this Message

VENKAT - 23 Oct 2004 04:33 GMT

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

> Ok, VENKAT, I know this function, but it permit that I modify only one
> cell
[quoted text clipped - 13 lines]
>> --
>> Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Reply to this Message

Jack Schitt - 17 Oct 2004 10:17 GMT

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)

Signature

Return email address is not as DEEP as it appears

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

Reply to this Message

P. Nogueira - 23 Oct 2004 02:11 GMT

Thank you Jack. I`m going to try.

> I think that goalseeker only allows you to modify one variable.
> To modify more than one variable use Solver.
[quoted text clipped - 3 lines]
> > than
> > one cell?

Reply to this Message