I have 2 cells A1 and B1. A1 is connected to an API data feed so the value is changing practically every second. when its value is <= to B1, how can I hold let’s say a value of 1 in cell C1. Even if the value in A1 moves above and below B1? I’m trying to hold and store a value of 1 to trigger my worksheet_calculate (). C1 =IF(A1>=B1,1,0)