Quadratic equation

Hello,

Does anyone know how to calculate quadratic equation using Excel?

Thank you very much for your help,


Nes

Dear Nes

The quadratic equations are generically of the form :-

ax2 + bx + c = 0 (The 2 refers to x raised to the power of 2)

The generic solution to the above equation is given by the following :-

(-b + (or -) (b2 - 4ac)0.5)/2a (The 0.5 refers to the square root of the entry((b2-4ac) - the 2 in b2 refers to the square of b!

Do this :-

Enter in cells A1, B1 and C1 the values of the constants 'a', 'b' and 'c' of the quadratic equation in question and then in cells A1 and A2 enter the following formulas :-

A1 -> =(-B1+POWER((POWER(B1,2)-(4*A1*C1)),0.5))/(2*A1)
A2 -> =(-B1-POWER((POWER(B1,2)-(4*A1*C1)),0.5))/(2*A1)

These 2 formulas will give you the 2 values that you would need as the 2 answer of the quadratic equation.

Hope this helps!


Best regards


Deepak Agarwal