Hello everyone,
Can someone help me figure out formula so that I can extract quadratic a, b, c values from given equation?
1st. Example: x^2-11x+30=0. Formula should output a:1, b:11, c = 30.
2nd Example: 2x^2+3x+1=3. Formula should output a:2, b:3, c = -2.
Much help is appreciated.
P.S. I'm attaching my excel sheet.
Last edited by Ciklopaz; 01-11-2020 at 02:05 PM.
I've had a quick go ... I'm sure there are much more elegant ways to do it, but this (or actually these) solutions are what came to mind immediately. I've done 2 versions, as the first solution resulted in blank for no term, and didn't convert to values, so the second set is to the right of the first. See attached:
You can parse your formula with these functions.
In B3
=IF(FIND("x2",A3)=1,1,INT(LEFT(A3,FIND("x2",A3)-1)))
In C3
=INT(IF(MID(A3,FIND("x2",A3)+2,FIND("x",A3,FIND("x2",A3)+2)-FIND("x2",A3)-2)="+",1,MID(A3,FIND("x2",A3)+2,FIND("x",A3,FIND("x2",A3)+2)-FIND("x2",A3)-2)))
In D3
=MID(A3,FIND("x",A3,FIND("x2",A3)+2)+1,FIND("=",A3)-FIND("x",A3,FIND("x2",A3)+2)-1)
You can then use the standard formula for extracting the roots
Martin
Re: Extract quadratic equation a, b, c values from given equation
Thanks for yours time, but mrice formula is more elegant. Thanks again for helping me out!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks