Solve a equation with x in the second power

[sibbles]

Hello

Need help solving x out of this kind of equation:

x^2*234+x*123+2345=0

Any idea if I can use a simple command in excel to solve this, have looked over the normal fx statements and can´t find any solvers.

Regards
Atli F.

 

[tusharm]

No need for VBA. As has already been shared with you, the formula will give you both answers while either Goal Seek or Solver will give you one real solution (as long as at least one exists).

If you want packaged polynomial answers using formulas see
Solve Polynomials
http://www.tushar-mehta.com/excel/software/polynomials/index.html

Just tried it in Solver and it isn't working for me either - looks like it will have to be VBA and a long wait unless anyone else has any other ideas.....

 

[PrinceNeptune]

x^2*234+x*123+2345=0

Just to point out, I am not sure if anyone has come right out and said it, but this equation can never equal 0. So if you are having problems, it isn't excel, it is the equation.

 

[Peter_SSs]

PrinceNeptune

Loose Cannon did point that out on the first page of this thread:

Sibbles, you are unable to get an answer on your equation from Excel because the solutions to your equation are non-real.