Value in cell between value in 2 other cells

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Totaling Cells with Like Information 3
calculating a pattern 4
Excel 2002 - link columns across workgroups 3
Lookup query 4
Macro to pull data with criterea for placement on a new sheet 7
Displaying missing values 1
How do I copy columns when part of formula has another sheet in it 1
Formula Based On a Check Box 2

Top