Hi. Just curious. With iteration turned on, I get a value for M4 of
0.0157487504127926. Is that what you have also?
I couldn't get any other values. However, If I'm not mistaken, I believe
there are 3 Real solutions, and 4 Imaginary solutions.
The other 2 Reals a
0.00076474810382905
and
-0.00077691667356448

Hope I got that right. Are I4 & K4 variable inputs ??

--
Dana DeLouis
"To understand recursion, one must first understand recursion."
Win XP & Office 2003



"LaserDude" wrote in message
...
My spreadsheet contained an error: The equation for L4 in my original
post
referenced an incorrect cell. The exact formulae a

H4=I4+J4+K4
I4=60.73
J4=49.0/(2*254*M4*0.342)
K4=23.128
L4=(I4+H4+K4)/2
M4=(-1.8484E-15*L4^6) + (9.4220E-13*L4^5) - (1.5108E-10*L4^4) +
(5.7474E-09*L4^3) + (7.0730E-07*L4^2) - (5.5519E-5*L4) + 1.6117E-2

After making the correction it solved immediately!

Thanks for your help.

Peter

"JE McGimpsey" wrote:

J4 will return a #DIV/0 error if M4 is zero. M4 depends on I4, so
again, without knowing what "function()" is, it's impossible to know
what's going on, except that M4 returning #VALUE! probably means that L4
returns the wrong type of argument.

L4 would appear to return #VALUE! only when "constant" is not numeric.

You have no circular references here, unless your missing K4 function
creates one, so it's not surprising that setting Iteration doesn't solve
the problem.

What are your exact formulae?

In article ,
LaserDude wrote:

The following will not solve (or start to solve?):

H4=I4+J4+K4
I4=60.73
J4=constant/(constant*M4)
L4=(I4+constant)/2
M4=function(L4)

I get this error on cells H4, J4, L4, and M4: #VALUE!

Sometimes J4 gets a #DIV/0! error.

I know this converges, as other programs using these formulae will
converge.

Does excel assume 0 for inital guess? -this would explain the #DIV/0
error.
Is it posible to assign an initial guess for the cells in question?

Iteration is enabled with 100 maximum iterations, and 0.1 maximum
change.

I appreciate any help on this!

Peter