What I have is a worksheet that automatically updates info into it every minute. I have a cell that evaluates if the inported data is true or false. I want another cell to enter the current time when the true statement is activated. This cell should retain the previous true statements value until a new true statment is made. For example:
At the listed times, A1 & B1 should read as follows:
11:02 A1=FALSE B1=11:01
11:01 A1=TRUE B1=11:01
11:00 A1=TRUE B1=11:00
10:59 A1=FALSE B1=10:56
10:58 A1=FALSE B1=10:56
10:57 A1=FALSE B1=10:56
10:56 A1=TRUE B1=10:56
Can an If statement be used?
Something like: =IF(A1=TRUE,now(),)
Any help out there?
Thanks
At the listed times, A1 & B1 should read as follows:
11:02 A1=FALSE B1=11:01
11:01 A1=TRUE B1=11:01
11:00 A1=TRUE B1=11:00
10:59 A1=FALSE B1=10:56
10:58 A1=FALSE B1=10:56
10:57 A1=FALSE B1=10:56
10:56 A1=TRUE B1=10:56
Can an If statement be used?
Something like: =IF(A1=TRUE,now(),)
Any help out there?
Thanks