IF function and countdown

[bygum]

Hello There

In A1 I have initiated a countdown from any number to zero,I created that in VBA.I then created an IF function and placed another value into B1.(the number 2)

When the countdown starts and reaches a certain number I want Cell C1(the function cell) to say "hello"'This happens because both conditions in Cell A1 and and B1 are true.
However when the the countdown continues,C1 just goes back to reading false because cell A1 is no longer true:

=IF(AND(A1=TIME(0,1,20),B1=2),"hello")

My question is this...is there any way I can keep the text in C2 even when the countdown makes the condition false,or put anotherway despite the logic no longer being true the "hello" will remain.
Any help appreciated on this function.
Kind Regards
Bygum

 

[iliace]

Could you make it <= since it is counting down?

=IF(AND(A1<=TIME(0,1,20),B1=2),"hello")

 

[bygum]

Hi iliace

Great! Works perfect.Many thanks Ive been scratching my head on that one for quite few hours

bygum