Having trouble with a formula that involves IF, AND and maybe OR.

[acmarston]

Having trouble with this IF AND OR formula. What I'm trying to come up with is this:

If Sheet1!D3=B4 and if Sheet1!E3<=C4 and if Sheet1!E3>=D4 and if Sheet1!F3<>E4 and if Sheet1!J3<=G4 and if Sheet1!K3=H4 and if Sheet1!N3<=I4 and if Sheet1!O3=J4 and if Sheet1!C3<=K4 and IF Sheet1!C3 is equal to 2 OR 3 THEN THIS Sheet1!Q3<=L4 and if Sheet1!T3<=M4 and if Sheet1!T3>=N4 THEN PUT "YES", OTHERWISE PUT "NO"

So, What I'm looking for is either Yes or No to show up. But I've been having trouble when it comes to this part: and IF Sheet1!C3 is equal to 2 OR 3 THEN THIS Sheet1!Q3<=L4

What I'm stuck on with that part is I don't know how to make it do this equation: Sheet1!Q3<=L4, ONLY if Sheet1!C3 is equal to 2 OR 3, and have it nested within the rest of it.

Can someone help me out with this?

Thanks.

[bebo021999]

Follow exactly what you said in words, try:

Please Login or Register  to view this content.

[Gregb11]

Not sure if I follow exactly, but try this:

=IF(AND(Sheet1!D3=B4,Sheet1!E3<=C4,Sheet1!E3>=D4,Sheet1!F3<>E4,Sheet1!J3<=G4,Sheet1!K3=H4,Sheet1!N3<=I4,Sheet1!O3=J4,Sheet1!C3<=K4,Sheet1!Q3<=L4,OR(Sheet1!C3=2,Sheet1!C3=3),Sheet1!T3<=M4, Sheet1!T3>=N4),"YES","NO")

[acmarston]

Thanks, but it still isn't what I'm looking for. The main part I'm trying to get it to do is include this in the formula: Sheet1!Q3<=L4 ONLY if Sheet1!C3 is equal to 2 OR 3. So, I need all the requirements to be true, but only require the Sheet1!Q3<=L4 to be true IF Sheet1!C3 is equal to 2 OR 3. If that makes sense. This is the only part I'm stuck on.

[bebo021999]

This part could be:
AND(Sheet1!Q3<=L4,OR(Sheet1!C3=2,Sheet1!C3=3))

[acmarston]

The only problem is, if Sheet1!C3 equals something other than 2 or 3, I still need it to give a "Yes".

If I test it and change Sheet1!C3 to "1", the formula gives a "No".

I need it to do Sheet1!Q3<=L4, only if Sheet1!C3=2,Sheet1!C3=3, OTHERWISE ignore the Sheet1!Q3<=L4. If that makes sense.

[Gregb11]

=IF(AND(Sheet1!D3=B4,Sheet1!E3<=C4,Sheet1!E3>=D4,Sheet1!F3<>E4,Sheet1!J3<=G4,Sheet1!K3=H4,Sheet1!N3<=I4,Sheet1!O3=J4,Sheet1!C3<=K4,OR(AND(Sheet1!Q3<=L4,OR(Sheet1!C3=2,Sheet1!C3=3)),AND(Sheet1!C3<>2,Sheet1!C3<>3)),Sheet1!T3<=M4, Sheet1!T3>=N4),"YES","NO")