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 lets 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)