goal seek minimize function

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Sep 18, 2006.

  1. Guest

    Guest Guest

    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.
     
    Guest, Sep 18, 2006
    #1
    1. Advertisements

  2. Guest

    Dana DeLouis Guest

    > 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. :>)

    --
    Dana DeLouis
    Windows XP & Office 2003


    "TaiwanSwede" <> wrote in message
    news:...
    >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, Sep 18, 2006
    #2
    1. Advertisements

  3. Guest

    Dana DeLouis Guest

    > 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. :>)

    --
    Dana DeLouis
    Windows XP & Office 2003


    "TaiwanSwede" <> wrote in message
    news:...
    >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, Sep 18, 2006
    #3
  4. Guest

    Guest Guest

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



    "Dana DeLouis" wrote:

    > > 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. :>)
    >
    > --
    > Dana DeLouis
    > Windows XP & Office 2003
    >
    >
    > "TaiwanSwede" <> wrote in message
    > news:...
    > >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.

    >
    >
    >
     
    Guest, Sep 19, 2006
    #4
  5. Guest

    Guest Guest

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



    "Dana DeLouis" wrote:

    > > 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. :>)
    >
    > --
    > Dana DeLouis
    > Windows XP & Office 2003
    >
    >
    > "TaiwanSwede" <> wrote in message
    > news:...
    > >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.

    >
    >
    >
     
    Guest, Sep 19, 2006
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Matt

    Goal Seek (in VBA)

    Matt, Aug 14, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    251
  2. Guest

    Goal Seek on PMT function give different answer than a mortgage ca

    Guest, May 22, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    297
    vandenberg p
    May 22, 2006
  3. Guest

    Can I use the Goal Seek function on multiple cells simultanously?

    Guest, Jun 2, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    585
    Guest
    Jun 2, 2006
  4. Guest

    goal seek minimize function

    Guest, Sep 18, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    169
    Guest
    Sep 18, 2006
  5. Guest

    i think i need goal seek or other type of statistic function

    Guest, Feb 8, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    171
    Guest
    Feb 8, 2007
Loading...

Share This Page