Goal Seek Problem

H

herringk

I am having trouble with the goal seek function not converging on a solution.
I can manually manipulate the numbers and make it converge but “goal seekâ€
will not converge. There is a circular reference involved (intentionally).
This is a spreadsheet that worked fine as a Excel 2003 worksheet but only
works sometimes works now that I have converted it to a Excel 2007 worksheet.

I have played with the iteration settings (number of iterations and maximum
change) but cannot find any pattern as to why it works sometimes and not
others. Any help would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top