Support Board

Date/Time: Fri, 03 May 2024 14:54:52 +0000

Post From: Spreadsheets; formula works in excel but not in Sierra Charts

[2015-12-04 03:22:36] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3992
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.