IF AND Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 you mean less than and not <= the following should work
=IF(AND(C2=C3,B2<(5/24/60/60)),TRUE,FALSE)

Regards

Da
 
Back
Top