VBA/UDF to find real roots of a 6th degree polynonial equation.

[Curious_george]

Can anyone please help me or point me in a direction? I am trying to find the real roots of the equation below using VBA/UDF in excel. Thanks in advance. Equation: y= x⁶ - 7x⁵ + 4x⁴ - 14x³ + 12x² - 5x + 23 = 0

 

[tusharm]

In general, you have to use numerical methods to find roots of a 6th order polynomial -- unless you can somehow factor the polynomial into cubic / quadratic equations. Good ideas include
roots - Solving a 6th degree polynomial equation - Mathematics Stack Exchange
Roots of polynomial of degree 6 - Mathematics Stack Exchange
and
How to solve an nth degree polynomial equation - Mathematics Stack Exchange

Can anyone please help me or point me in a direction? I am trying to find the real roots of the equation below using VBA/UDF in excel. Thanks in advance. Equation: y= x⁶ - 7x⁵ + 4x⁴ - 14x³ + 12x² - 5x + 23 = 0