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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History