MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Optimization code

  Asked By: Jayden    Date: Sep 11    Category: MS Office    Views: 1508

Is there a simple way to maximize or minimize an equation (that is
given in a cell)?

I've written linear optimiation (price-ratio-pivot) stuff and non-
linear optimization code in FORTRAN, but this looks like there should
be a simpler way than re-writing it.



1 Answer Found

Answer #1    Answered By: Cheryl Murphy     Answered On: Sep 11

For optimization  in Excel, you can use the "Solver Add-In". You need
to enable it by going Tools, Add-Ins... and checking the box for
Solver. (It also may need to be installed from the Excel CD.) Once it
is there, go to Tools, Solver, and fill in the form. It is pretty nice.

Didn't find what you were looking for? Find more on Optimization code Or get search suggestion and latest updates.