Restricting a Formula's Response

[Stonewall]

I am in the midst of a project where I must compute the allocation of an
account by the use of different funds (mutual). My problem is that I also
need to find a way to restrict one of my formula responses because there is a
restriction on one of the funds (it can only be changed by x%). In order to
reallocate money into different funds I need to take this restriction into
account because I am moving money from fund to fund. I tried to use Goal
Seek, but that wasn't successful for my purposes.

Thanks in advance.

 

[Niek Otten]

You probably need Solver instead of Goal Seek.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



|I am in the midst of a project where I must compute the allocation of an
| account by the use of different funds (mutual). My problem is that I also
| need to find a way to restrict one of my formula responses because there is a
| restriction on one of the funds (it can only be changed by x%). In order to
| reallocate money into different funds I need to take this restriction into
| account because I am moving money from fund to fund. I tried to use Goal
| Seek, but that wasn't successful for my purposes.
|
| Thanks in advance.

 

[Stonewall]

Thanks, that was perfect.