Login Page - Create Account

Support Board


Date/Time: Thu, 28 Mar 2024 09:24:59 +0000



Post From: Time Period Volume (and Text Display)

[2021-09-16 07:40:39]
User907968 - Posts: 800
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])