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.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies