Solved how to find value using ?

November 4, 2015 at 14:13:25
Specs: Windows 7
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


See More: how to find value using ?

Report •


#1
November 4, 2015 at 17:24:21
Your use of the <> symbol is confusing.

Can you just describe in words what it is you want.

MIKE

http://www.skeptic.com/


Report •

#2
November 4, 2015 at 20:13:30
✔ Best Answer
I can't tell if you want to check if A2 is within 2 minutes of A1 or beyond 2 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.


Report •

Related Solutions


Ask Question