Home

Excel error solving

%3CLINGO-SUB%20id%3D%22lingo-sub-792581%22%20slang%3D%22en-US%22%3EExcel%20error%20solving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792581%22%20slang%3D%22en-US%22%3E%3CP%3E1.%20What%20value%20is%20the%20best%20to%20set%20in%26nbsp%3B%3CSTRONG%3EMaximum%20Iterations%20%3C%2FSTRONG%3Ebox%20and%26nbsp%3B%3CSTRONG%3EMaximum%20Change%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bbox%20while%20use%26nbsp%3B%3CSTRONG%3EEnable%20iterative%20calculation%26nbsp%3B%3C%2FSTRONG%3Ein%20excel%20%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E2.%26nbsp%3B%20What%20are%26nbsp%3B%3CSTRONG%3Eeffect%3C%2FSTRONG%3Ewhile%20maximum%20change%20value%20set%20to%20zero%20and%20maximum%20iterations%20value%20set%20to%20one%20of%20enable%20iterative%20calculation%20in%20excel%20is%20zero%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E3.%20Why%20excel%20show%20the%20different%20amount%20while%20summing%20the%20divided%20cell%20range%20which%20are%20not%20different%20amount%20before%20dividing%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-792581%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793191%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20error%20solving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793191%22%20slang%3D%22en-US%22%3E1%3A%20Impossible%20to%20answer%2C%20this%20depends%20on%20the%20characteristics%20of%20your%20model%3CBR%20%2F%3E2%20and%203%3A%20I'm%20not%20sure%20I%20understand%20your%20questions%3F%3CBR%20%2F%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fjkp-ads.com%2FArticles%2Fcircularreferences00.asp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjkp-ads.com%2FArticles%2Fcircularreferences00.asp%3C%2FA%3Efor%20information%20about%20circular%20references.%3C%2FLINGO-BODY%3E
Aung_Soe
Occasional Visitor

1. What value is the best to set in Maximum Iterations box and Maximum Change box while use Enable iterative calculation in excel ?

 

2.  What are effect while maximum change value set to zero and maximum iterations value set to one of enable iterative calculation in excel is zero?

 

3. Why excel show the different amount while summing the divided cell range which are not different amount before dividing?

1 Reply
1: Impossible to answer, this depends on the characteristics of your model
2 and 3: I'm not sure I understand your questions?
See https://jkp-ads.com/Articles/circularreferences00.asp for information about circular references.