Support Board
Date/Time: Sat, 11 Jan 2025 06:44:45 +0000
New Spreadsheets Syntax Error
View Count: 680
| [2016-11-18 12:25:02] |
| user58907 - Posts: 83 |
|
Within the same spreadsheet window, I have a summary sheet which gets data from the other sheets. This formula works in the old spreadsheets, not in the new. =IF(SPX5m!K$3=0,0,+SPX5m!AA$3) I have also tried =IF(SPX5m!K$3=0,0,=SPX5m!AA$3) and get the same error. Please advise, thanks. |
| [2016-11-18 16:56:32] |
| |
|
Remove the +: =IF(SPX5m!K$3=0,0, SPX5m!AA$3) Also make sure there is a Sheet with the name "SPX5m" within the Spreadsheet. 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: