INQUIRE FOR SOLVER CIRCULAR FORMULATION - money wizards

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am eager to know the limitation of the standard solver add-ins with the
circular formulation of worksheets in a single workbook. How many
circular-looping formulation is possible in a one set of Solver parameter -
Say the target is for minimum Cost - in one workbook ?
Thanks for any reply !!!
romelsb
 
From Excel Help | Excel Specifications and limits
Adjustable cells in Solver: 200
 
Thanks Jlatham,
Will solver work out when there is one loop of circular formulation and
wherein one of the solver constraints is within the equated loop ?
 
I think you are asking if it can deal with a circular reference, and I
believe the answer is YES, it can. But I do not use solver very often at
all, and I may be wrong.
 
thanks and more power

JLatham said:
I think you are asking if it can deal with a circular reference, and I
believe the answer is YES, it can. But I do not use solver very often at
all, and I may be wrong.
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

How do I locate a circular formula? 2
Excel 2003 + Solver 3
How accurate is SOLVER? 1
formulation setup() from 2003 good for 2007 2
how can I compensate this...pleass contribute... 2
Is there a single function that duplicates Solver? 1
Solver (Formula Version) 1
How to get Solver to target array rather than cell? 3

Back
Top