Support Board
Date/Time: Thu, 25 Dec 2025 12:15:19 +0000
Post From: Spreadsheets; formula works in excel but not in Sierra Charts
| [2015-12-04 03:22:36] |
| Sawtooth - Posts: 4300 |
|
Not sure. I've tried various combinations with INDIRECT using TEXT and CONCATENATE and VALUE to achieve what you are trying to do. I was unsuccessful. I was able to use OFFSET in my application as a workaround. My suggestion will allow you to find the MIN of a dynamic range, which seems is what you want to do. Here are the New Spreadsheet functions: http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html#AvailableFunctions This is fewer than in Excel, and not all of them work as they do in Excel, which means the New Spreadsheets are not really Excel compatible. |