Cubic Equation on Excel, simple, no iteration or macro.
Only 4 cells input and 1 cell output. These can be put into your own spreadsheet.
You can examine the formulas. Nothing hidden.
Based on Eric Schecter equations on https://math.vanderbilt.edu/schectex/courses/cubic/ 12/4/16.
It either gives a good result or a #NUM! error. I speculate that it is giving the good result when there is one root. That can be useful in many problems. I speculate that it is giving the #NUM! error when there are two or three roots. I speculate this occurs when it must take square roots of negative numbers.
087_Cubic_Equation.xls
12/7/16, 12/26/16