Support Board
Date/Time: Sun, 24 Nov 2024 05:54:13 +0000
Post From: S/Sheet Study - Formula returns #inval! error
| [2013-09-24 21:16:45] |
| |
|
We have looked into this. 1. The issue with this formula boils down to INDEX(...):INDEX(...). The colon in this context is the syntax error. This is not supported in the new spreadsheets. The other colons in the formula are valid because they are part of cell range references (X3:X1002), but a colon currently has no meaning between two values. 2. Also, the function COUNTIF was never added due to the complexity of supporting criteria text. (Same with AVERAGEIF, MAXIF, MINIF, SUMIF.) You should be able to accomplish what that formula is doing by breaking the formula down into separate spreadsheet columns using the more basic functions. Now that 60 formula columns are supported with the spreadsheet studies, there should be no problem with this. It also may make it easier to understand the logic. 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: 2013-09-24 21:17:40
|