Login Page - Create Account

Support Board


Date/Time: Sun, 19 May 2024 07:24:01 +0000



Post From: simple counting spreadsheet cell

[2015-05-24 19:57:04]
SSGill - Posts: 35
Hello;

I am using SC spreadsheet for trading. I'm using version 1258. In the old spreadsheets. This is on a one minute chart.

In cell p3, this formula =IF(P4=20,1,P3+1), I would have expected to count on each new row of data, instead, it updates it seems every time the data changes on the chart. 10-20 times per minute.

Another issue is that in the following columns, I don't see a counting on each row, but a repeat of the same number that changes in cell p3, again 10-20 times per minute.


imagetemp.PNG / V - Attached On 2015-05-24 19:55:29 UTC - Size: 68.57 KB - 324 views