Support Board
Date/Time: Fri, 09 May 2025 15:24:10 +0000
Post From: Time Period Volume (and Text Display)
| [2021-09-16 07:40:39] |
| User907968 - Posts: 840 |
|
This error makes sense, since the IF statement is basically computing the sum at that exact time, else it's returning an empty cell.
No, if your study ID is set correctly in the formula, it will only return 0 up until the volume is first calculated, after which it will return the last calculated volume, i.e. the calculated volume is copied from the preceding index. What is the study ID of your Spreadsheet Formula, this need to be inserted in place of 'ID1' (if not ID1). =IF(BARTIME=TIME(09,34,00),SUM(V[0:-4]),ID1.SG1[-1]) |