Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Goal Seek on PMT function give different answer than a mortgage ca | Excel Worksheet Functions | |||
Null values in charts and how to override the goal seek functionality | Charts and Charting in Excel | |||
Goal Seek | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel |