Thread: IF AND Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default 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.