Support Board
Date/Time: Wed, 27 Nov 2024 10:36:48 +0000
Post From: Help with New Spreadsheets for non-CLR (Iteration?)
| [2014-08-15 17:19:42] |
| |
|
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
|