IF AND Question
 

I a trying to write a formula that gives the result in ColA.

If "Code" Row N+1 = Code Row N and TimeDiff Fow N+1 is less than 5 seconds,
return TRUE. Otherwise, FALSE

TimeDiff Code
FALSE 9:31:16 UMUD06C30.00
FALSE 0:00:21 QAAE06C65.00
TRUE 0:00:04 QAAE06C65.00
FALSE 0:00:09 DLQD06C30.00
TRUE 0:00:03 GG E06C32.50

Thank you in advance.

IF AND Question
 

If you mean less than and not <= the following should work
=IF(AND(C2=C3,B2<(5/24/60/60)),TRUE,FALSE)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=540286