• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to solve 4th, 3rd and 2nd order eqaution using VBA

nagovind

nagovind

Member
I have equation like below

each r different equation


AX^4 + BX^3 + CX^3 + DX + E = 0 i need x1, x2, x3 and x4

AX^3 + BX^2 + C X + D = 0 i need x1, x2 and x3

AX^2 + BX + C = 0 i need x1 and X2


Is it possible in Excel VBA ?
 
If its a one time task, you could try the goal seek


Ive used the built for quadratic equations, works fine


You will have to run it more than once for both roots


(havent used it for 3rd or 4th order eq)
 
Nagovind

Have a read of http://newtonexcelbach.wordpress.com/2010/08/04/solving-cubic-and-quartic-equations-with-excel/
 
With an update at

http://newtonexcelbach.wordpress.com/2010/09/19/complex-numbers-and-solving-quartic-polynomial-equations/
 
You must log in or register to reply here.
Back
Top