Need formula for Circular Reference Problem - solved by activating Iterative Calculations

[Shetal Shah]

Dear Chandoo & Members,

I have an issue in excel with the Circular Reference Error.

Have already tried the option of activating Iterative Calculations from the link below & it worked.

http://forum.chandoo.org/threads/need-formula-to-avoid-circular-references.16380/

However, Chandoo had already provided an option of a formula using a mathematical formula... which was amazing!

Taking reference of the same, even i tried to make a formula, but could not.

File attached for reference. The issue is with the miscellaneous allowance.

Please refer attached file & support me.

Thank you in advance.

Regards,
Sk

 

[Ramesh]

I see all these circular references are caused by one formula written in cell I2 and I3..where the formula is including the cell H2 which intern is referred across the other formulas..when I modified the formula to exclude this reference all the ciruclar references is are eliminated..

Anytime, if you want to see the list of cells which are impacted by the circular references you can refer to Formulas Tab=> Error Checking dropdown in Formula Auditing section and select Circular References