Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 18:47:04 +0000

How to Post a Message for Support

Post From: spreadsheet documentation suggestion

[2020-05-09 15:43:24]
[Go To First Post]
User476002 - Posts: 28
Hi when I follow the instructions for indirect at https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#INDIRECT_Function I don't get the expected behavior

"An example ReferenceText is "E3". ReferenceText can be created by a formula. For example, if cell H5 contains the number 3, then the following formula will return E3: CONCATENATE("E", TEXT(H5))."

if I remove "text" before the cell reference it works. Just thought you might consider changing, could save someone some time in the future.