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(A 1=A4,A1<=B4)),"YES","NO")

--
HTH

Bob

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

"GregNga" wrote in message
...
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