Extracting the first and second coefficient from equations

[andreascostas]

I am using =(left(C1,1)=”x”,1,0+(LEFT(C1,Find(“x”,C1)-1)) to extract the first coefficient from formulas. This works for the first and second equations but not the third.

- 9x - 9y = 54 yields -9


x + y = -4 yields 1

- x - 7y = -33 yields #value

How can I adjust that to work for all situations.

Also how do I extract the second coefficient of each equation, in a separate cell

Thanks

 

[BrianJN1]

How exactly have you set this up?
Your formula has some issues the first is that is is missing a last ")", but even then the Excel translator reports some unidentified error.

 

[Rick Rothstein]

Assuming your first equation is in cell A1, put these formulas in the indicated cells and then copy them down to the end of your data...

B1: =0+(LEFT(SUBSTITUTE(" "&A1," x","1x"),FIND("x"," "&A1)-1))

C1: =0+MID(LEFT(SUBSTITUTE(A1," y","1y"),FIND("y ",A1)-1),FIND("x",A1)+2,99)

 

[andreascostas]

Thank you Rick.