Please supply your formulas, the values of the precedent cells, the result(s) you expected and what you got instead.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Smita" wrote in message ...
| Hello,
|
| I have about 100 projects over which I allocate worked hours (40) for
| managers. These are allocated in proportion to the weight of the project
| relative to other projects. I use goal-seek to do this. This process is done
| on a weekly basis and new projects are added and old removed.
|
| Here is my question. I have noticed that goal-seek has a bias in that it
| allocates only to the projects which have the highest weight, leaving out
| others. So the result is that some projects get hit hardly whereas, others do
| not.
|
| Is there anything else I can do to even out this? Or even more importantly
| is my assumption of bias correct? Any thoughts? How does goal-seek internally
| work?
|
| Thanks much.