Solver (Formula Version)

[Thomas]

Dear all,

I would like to use the solver function, but I want the
worksheet to calculate automatically. Therefore, I don't
want to use the solver addin.

So, is there any example that could show the function of
solver without using the solver addin?

My case is, I have
Cost A1
Profit Margin B1
Delivery C1
Target Sales Price D1

A1 is independent, B1 is my target, C1 depends on a
portion of D1, D1 is A1 times B1 + C1.

As there is a loop in B1, C1, D1, solver is required.

Any advice?

Thanks
Thomas

 

[Tushar Mehta]

The very nature of Solver precludes its use as a function. Until MS
allows an entire worksheet to act as a function, there is no way to
create a totally general purpose optimization function.

That said, is it possible your problem doesn't require a loop?
Depending on the relation between C1 and D1, D1= A1 *(B1+C1) and a
little algebra should yield any variable as a function of the other
three.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004