goal seek minimize function

[TaiwanSwede]

I would like to optimize shipment sizes by taking both shipment and storage
costs into account.

I would like to use the goal seek function to minimize the value in a
certain cell (total cost) by changing another the value in another cell
(shipment size).

However, I have found that the goal seek function is set up in such a way so
that the value in the goal seek cell is set to a certain value and that there
is no way to minimize that value. Did I miss anything? Or I should just set
value to zero to minimize it.

 

[Dana DeLouis]

I would like to use the goal seek function to minimize the value in a

certain cell (total cost)

Hi. It sounds like Excel's "Solver" would be a better tool. It's an
Add-Inn, so first enable it via Tools > Add-Ins.. > Solver.
Then run it with Tools > Solver...
Hope this helps. Post back if you have any questions on Solver. :>)

 

[TaiwanSwede]

Seems that's exactly what I'm looking for. Thanks a lot Dana.