Restricting a Formula's Response
Thanks, that was perfect.
"Niek Otten" wrote:
You probably need Solver instead of Goal Seek.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Stonewall" wrote in message ...
|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.
|