View Single Post
  #7   Report Post  
Xtian
 
Posts: n/a
Default

Hi George,
I've made a mistake during testing. Ewerything works fine. Thank you!
Kristijan.

Korisnik "GeorgeF" napisao je:


Hi Kristijan,
In your expression of the 2-power equation, you state that you know, a,
b, c, and Y. Reexpess your equation as a typical quadratic as:

aX^2+bX+C, where C = c-Y

The only unknown in the above is X. Place the values for a, b, and the
new C in three cells A1, B1, and C1.

In D1 write: =(-B1+(B1^2-4*A1*C1)^0.5)/(2*A1)

In E1 write: =(-B1-(B1^2-4*A1*C1)^0.5)/(2*A1)

D1 and E1 are the two numerical solutions of X and your judgement will
tell you of their reality
I hope this helps. GeorgeF.


--
GeorgeF
------------------------------------------------------------------------
GeorgeF's Profile: http://www.excelforum.com/member.php...o&userid=24124
View this thread: http://www.excelforum.com/showthread...hreadid=391307