- Create An Excel Spreadsheet That Will Determine The Roots Of A Quadratic Equation In Terms Of The Coefficients A B And 1 (126.07 KiB) Viewed 13 times
Create an Excel spreadsheet that will determine the roots of a quadratic equation in terms of the coefficients a, b, and
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Create an Excel spreadsheet that will determine the roots of a quadratic equation in terms of the coefficients a, b, and
Create an Excel spreadsheet that will determine the roots of a quadratic equation in terms of the coefficients a, b, and c. In the case of complex roots, use the TEXT library function to convert the imaginary number to a string (i.e., a label), and then combine the resulting string with the letter i using the string operator (&). Enter the following sets of coefficients in your worksheet, and determine the roots corresponding to each set: (a) a= 2, b=4, c = 1 (b) a=4, b=2, c = 3