solver doesn't find all solutions

[Alexander_Golinsky]

Hi all!

If one runs excel solver on a quadratic equation with two cells as the arguments, then the solver will find one solution (one cell) but not the another one (2nd cell). The question is: how to force him to look for the all solution ??

[shg]

Why do you need Solver for a quadratic? Solve it in closed form.

EDIT: Never mind -- I see you've double posted here, and posted it many other places.

[Alexander_Golinsky]

Shg, This question is unique and not posted anywhere. The question about VBA solution to this problem is posted as another question on 3 forums and having cross links inside itself.

[shg]

Then the answer is, you don't need Solver for a quadratic.

[Alexander_Golinsky]

Shg, you're better trust me - i know what i need

[shg]

Trust me, you don't need Solver for a quadratic (which is the question you asked). Ask your favorite high-school freshman.