G
Guest
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
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