Excel Iterative calculations

P

petersampson

I use a spreadsheet with indirect circular cell references. When it works I
observe the iterations narrowing until I have a verifiable answer. However,
the iterations often expand (rather than narrow) leading to errors.
Is there anywhere I can read-up on iterative calculations in Excel?
 
E

Excelhobbyist

I don't have experience with it myself, but would have thought that the
'Watch' function does what you want? Tools/Formula Auditing/Show Watch window.
 
D

Dana DeLouis

Can you post the equation. We might be able to trap the input variable,
and make sure the equation does not diverge.
Dana
 
P

petersampson

Thanks for the offer Dana, the iterative calculation is contained on a
spreadsheet. Am I able to post the worksheet on this message?
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top