View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

I'm not sure why you need an iterative function. A little algebra gives

C4*E4^2 + E4 - A = 0

E4 = (-1 ± SQRT(1^2 - 4*C4*(-A)) ) / (2*C4)

So one solution for E4 will be

E4 = (-1 + SQRT(1+4*$C$4*A))/(2*$C$4)

and the other will be

E4 = (-1 - SQRT(1+4*$C$4*A))/(2*$C$4)



In article ,
Eddy VG wrote:

A mathematical formulae of the type A = E4*(1+(C4*E4)) in which C4 is a
fixed value and A has values listed in a row in an excel-worksheet.
The different values of E4 has to be determined as a function of A.
Is there a iteration function available and how should it be
specified.
All advice is appreciated!