Value in cell between value in 2 other cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

would like to have cell 1B be YES if 1A is between 2A and 2B or between 3A
and 3B or between 4A and 4B, otherwise cell 1B s/b NO.

How do I do this with a formula
 
=IF(OR(AND(A1>=A2,A1<=B2),AND(A1>=A3,A1<=B3),AND(A1>=A4,A1<=B4)),"YES","NO")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top