Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel solver should allow "equal to" value to be a selected cell.
I am trying to solve a log series equation in an Excel 2003 spreadsheet. I
want to have excel adjust a single variable in the equation to find a product equal to another value. The solver function ALMOST works, but requires that the "equal to" value be minimum, maximum, or a defined integer. I want to be able to set the "equal to" value as a selected cell, because the target value is the result of another formula and will be different each time I perform the operation. Is there another Excel tool that will allow me to do this? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
I want to use a formula in excel to highlight a cell 30 days prio | Excel Worksheet Functions | |||
how read value from last selected cell? It is possible? how get adress last selected cell? | New Users to Excel | |||
Perform oiperations relative to initial selected cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |