Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |