Excel solver should allow "equal to" value to be a selected cell.

[Guest]

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Tushar Mehta]

Calculate the difference in another cell. Now, in Solver, specify this new
cell as having a value of zero.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions