View Single Post
  #1   Report Post  
LaserDude
 
Posts: n/a
Default Circular Reference will not solve #VALUE! or #DIV/0!

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