Solve a equation with x in the second power

This is a discussion on Solve a equation with x in the second power within the Excel Questions forums, part of the Question Forums category; 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 ...

"The formulation of the problem is often more essential than its solution . If I had one hour to save the world, I would spend the first 55 minutes defining the problem and the last five minutes solving it." - Albert Einstein

You can now put the formula =QuadSolvePlus(A,B,C) into A4 and it will return x. Note two quirks of quadratic equations: first, many have non-real solutions (ie, contain a multiple of the square root of -1) and some have convergent roots (ie., QuadSolvePlus and QuadSolveMinus give the same solution for x.

"The formulation of the problem is often more essential than its solution . If I had one hour to save the world, I would spend the first 55 minutes defining the problem and the last five minutes solving it." - Albert Einstein

"The formulation of the problem is often more essential than its solution . If I had one hour to save the world, I would spend the first 55 minutes defining the problem and the last five minutes solving it." - Albert Einstein

Loose Cannon's (first post) formulas should work but, if you are trying to solve different equations with different coefficients, the the coefficients would need to be in different cells and his(?) formulas would need a, b, and c replaced by cell references. Note, too that the last formula given by Loose Cannon I think should start =(-b-SQRT...

We can use Goal Seek, but note that only approximate solutions will be obtained and only 1 solution when there might actually be two. Let's take a simpler quadratic equation to start with. X^2 + x - 6 = 0 This has solutions of 2 and -3. To get Goal Seek to find a solution, put this formula in B1:
=A1^2+A1-6
Now go Tools|Goal Seek|Set Cell B1|To Value 0|By changing cell A1|Ok
An (approximate) solution to the equation should appear in cell A1.

"The formulation of the problem is often more essential than its solution . If I had one hour to save the world, I would spend the first 55 minutes defining the problem and the last five minutes solving it." - Albert Einstein

I knew the abc formula for calculating out the formula, just wondering if excel has a simular functuion as my calculator (Casio fx9750 Plus) that solves the formula if you enter it in the same fashion as in my first post, guess I will have to make excel calculate the abc formula manually, as in your posts.

Thanks alot for those formulas, this forum is really a neccessity when using excel.

P.s. Will let you know my final formula and the result I will get from it