Hello,

This is not my first tim with excel solver in VBA. I built a spreadsheet where user can determine optimal ordering quantities to minimize total cost.
My cost function can not be evaluated at 0.
I only have two constraints which actually do allow my optimal result to be at 0, but since my function can not be evaluated at 0, I expect a diffrent answer.

Now sometimes I obtain an optimal 0 solution, but total cost can not calcultated. I then change the optimal result cell from 0 to any random number, and I solve again, and it gives the expected optimal solution.

what could be wrong??

Thank You,