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