Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Iterate Circular Reference | Excel Discussion (Misc queries) | |||
Highest Value / Circular Reference Help | Excel Discussion (Misc queries) | |||
Highest Value / Circular Reference Help | Excel Worksheet Functions | |||
Help solve a Circular Reference | Excel Worksheet Functions | |||
Circular reference | Excel Discussion (Misc queries) |