Solver configuration for a fairly complex sheet.

I notice that G27 is an INT() function and E17 includes a ROUNDDOWN() function. These functions tend to make "step" functions (or something otherwise discontinuos). Solvers (especially GRG algorithms that are similar to the old Newton's method) do not work well if at all on discontinuous functions. If you must use Solver for this, you should probably rethink your objective and constraint functions and see if you can make them continuous functions.

If you don't have to use Solver for this, I manually used a bisection algorithm to find a solution at G29=759. It only took a minute or so, it was tedious, but it was quick and easy. Would you be allowed to solve this manually outside of Solver? Of course, if you find a bisection or other algorithm reliable, it can be programmed into the spreadsheet or VBA without too much difficulty.

One tool that might be useful for this is to set up a data table (https://www.excel-easy.com/examples/data-tables.html ). By setting up a data table, you can quickly calculate G27 and E17 at multiple different values for G29 and see approximately where the minimum value for G27 that still meets the E17=1 criteria.

A couple of ideas. Let us know how we can help further.

Since you already know the result you want to achieve, (given by the "constraints" for Solver), we can build the solution working from top to bottom.

At the highest level, we set a 1 in U17. After that, at each step, we take into account the given owned and extra quantities like this

=IF(T18=0,(U17-B17-C17)*2,T18)

having copied the constraints in column T.

Changing the level of the starting 1, results are the same you get from the table (just copy U29 to G29).

HTH,

Francesco