Quadratic Equations.xls

(4/25)

Description

Quadratic Equation Solver with Graph

Finds the two real roots of a quadratic equation ax² + bx + c = 0, checks each root by substituting it back into the equation, and plots the curve with both roots marked so the answer can be seen as well as calculated.

Method

The quadratic formula, x = (−b ± √(b² − 4ac)) / 2a, with a discriminant check that the roots are real. The chart is drawn through points spaced either side of the roots, so it rescales automatically for any equation.

Inputs

  • Coefficients a, b and c
  • An optional sample value of x at which to evaluate f(x)

Outputs

  • f(x) at the sample value
  • A validity check (“Valid” when the roots are real and distinct)
  • Roots x1 and x2, each with f(x) evaluated at the root as a check (zero)
  • A chart of f(x) against x showing where the curve crosses the axis

The example, x² + 5x − 5 = 0, gives roots 0.8541 and −5.8541. Dimensionless; no units are needed.

Please note

  • Real roots only. If b² < 4ac the roots are complex, the check reads “Not Valid!” and the root cells show #NUM!. A repeated root (b² = 4ac) is also flagged “Not Valid!”, although the root shown is correct (the chart then collapses to a single point, as its x range is set from the gap between the roots).
  • a must not be zero (the equation is then linear).
  • No macros. The workbook has two sheets: a plain Excel version with the equations shown as pictures, and an XLC version whose equations update live and need the free XLC add-in.

Calculation Preview

20 Feb 2021
Downloads: 1781
File Version: 1.2
File Rating (4/25)

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 3
BillyNoMates 14 years ago
I updated the calculation to the ExcelCalcs calculation template and also included a native Excel version of the spreadsheet on a separate worksheet.
BillyNoMates 16 years ago
Simple typographical error has been corrected.
DvdHntr 19 years ago
Nice Spreadsheet