Finding Polynomial Roots

Does anyone know how I could find the roots of a polynomial up to 4 exponents? The requirements are that it must be on excel and I should be able to plug in the coefficients and get multiple roots. It has something to do with the IF function and does not require coding.

You will probably have to define the math problem a little better. I cannot think of a generic root finding algorithm for up to a 4th degree polynomial that is mostly based on an IF function.

The root finding algorithms that I am familiar with: http://en.wikipedia.org/wiki/Root-finding_algorithm Most of the time, we use Solver or Goal Seek (based on the Newton Raphson algorithm) because these are preprogrammed into Excel for us.

Solver and Goal Seek can be automated through VBA, but your OP suggested that your expected solution would not require any coding.