I am trying to use Solver to find the maximum investment growth for a business situation. The tricky thing is that one of the constraints is based on a cell that is derived from another cell, which in turn is calculated using Excel's "iteration" feature.
To illustrate:
One of Solver...