Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a single function that duplicates Solver?
I can use Solver to figure out what value one cell needs to take on in order
to maximize (or set to some value) some other cell. What I would like to do is to write a single function, in a single cell, that presents the OUTPUT of the Solver process. For example, I would be looking for a function of the type =SOLVER(a1,b1=max,"a2<5",...), where a1 is the cell to be changed, b1 is the cell to be maximized, and the constraints follow. Does such a function exist? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver Function - Making it Automatic | Excel Worksheet Functions | |||
Single list ~ not duplicates | Excel Discussion (Misc queries) | |||
Macros involving SOLVER... function | Excel Discussion (Misc queries) | |||
Solver problem where 'IF Function' is bad | Excel Discussion (Misc queries) | |||
Taking out duplicates from a single sheet | Excel Discussion (Misc queries) |