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

#### Curious_george

##### New Member
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= x6 - 7x5 + 4x4 - 14x3 + 12x2 - 5x + 23 = 0

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

#### tusharm

##### MrExcel MVP
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= x6 - 7x5 + 4x4 - 14x3 + 12x2 - 5x + 23 = 0