close

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

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

TimeDiffCode
FALSE9:31:16UMUD06C30.00
FALSE0:00:21QAAE06C65.00
TRUE0:00:04QAAE06C65.00
FALSE0:00:09DLQD06C30.00
TRUE0:00:03GG E06C32.50

Thank you in advance.


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

Regards

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄