I dont now where to begin so...
<*cell* M8> 2x^2-10x+8=0 What ive done so far in the cells: I4,J4,K4; <*cell* I4>=LEFT(M8;1) returns the value 2 <*cell* J4>=MID(M8;5;3) returns the value -10 <*cell* K4>=MID(M8;10;1) returns the value 8
and so far, its correct! (thats the answers i look for)
But i want a more dynamic function:
"But! if the cells M8 text, value, would be" -15x^2+101x-18=0 the left, mid-functions would not deliver the answers i would look for.
Im looking for an function that can make all of this true (bad joke)
- search"from left"stop before x^n return the value(-s) to designated cell (ex. I4)
- search after x^n take all the values before x return the value(-s) to designated cell (ex. J4)
- search after x take all the values before = return the value(-s) to designated cell (ex. K4)
(Sorry guys but im a noob so this is the best i could come up with!) Of Course...i know there is probably a ton of better solutions. Feel free to give them! I just dont now how to start or with function to begin with...