A1=7:20

A2=7:25

A3="Y"/"N" (formula)

how would i write if A2 is <> (by 2 minutes) A1?

If A2 is <> 2 minutes = "N" otherwise "Y"

Thx. hope this make sense.

message edited by fishruiz

Your use of the <> symbol is confusing. Can you just describe in words what it is you want.

MIKE

I can't tell if you want to check if A2 is within2 minutes of A1 orbeyond2 minutes of A1.Within:

=IF(AND(A2<A1+2/24/60,A2>A1-2/24/60),"Y","N")or

=IF(AND(A2<A1+0.00138888888888889, A2>A1-0.00138888888888889),"Y","N")

Beyond:=IF(OR(A2>=A1+2/24/60,A2<=A1-2/24/60),"Y","N")or

=IF(OR(A2>=A1+0.00138888888888889, A2<=A1-0.00138888888888889),"Y","N")

(I think)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll