Value in cell between value in 2 other cells

G

GregNga

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
 
B

Bob Phillips

=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)
 
Top