Support Board

Date/Time: Sun, 19 May 2024 04:11:12 +0000

Post From: Help with New Spreadsheets for non-CLR (Iteration?)

[2014-08-15 17:19:42] Link To Thread - Link To Post [Go To First Post]
Sierra Chart Engineering - Posts: 104368
You have a circular references and circular references are not supported in the new spreadsheets because there is not an accurate and efficient way to resolve them: Formula in Cell AD121: =IF(AND(OR(AD120=1;AD121=1);AD122=0);1;0) Formula in Cell AD122: =IF(AND(AD120=0;AD121=1;AD123=1);1;0) Do you have a an alternative to circular references that you can create for what you want to do? We do not understand your formulas well enough to suggest one. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, change to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2014-08-15 17:20:06