Cicular Reference

[bigmacfann]

Hello, I'm trying to figure out how to perform a circular reference involving several cells. In cell d2 I am trying to get a final loan amount which is contingent upon several fees associated with doing the loan; these fees are in separate cells. Currently I have in cell d2: =c2+f2+g2+h2+j2+m2 Cells c2, g2 and h2 are fixed amounts and depend on nothing related to d2. However, cells f2, j2 and m2 require a number in d2 in order to calculate properly. Cell f2 currently says: =d2*.045 Cell j2 currently says: =(d2*.125)/2 cell m2 uses the final number in d2 as part of a total calculation such as: =a2-d2-i2-l2 Obviously cell d2 is a circular reference, but how do I get the numbers in all of the cells to update automatically? Thank you so much in advance!

 

[bigmacfann]

I figured it out. In Excel Options, under the Formulas tab, you can check a box to enable iterative calculation and you can set the increments and so forth. This worked perfectly.