FALSE Result not desired

[MCosca]

I am using a logical 'IF' statement to distribute work to service providers. I have edited this to make it more specific however in certain circumstances the result is FALSE. The formula is below

=IF(W2="","",IF(W2="Close Even","U/W Process",IF(AND(F2=1,(LEFT(E2,7))=LEFT(E1,7)),X1,IF(T2="GC - Practice","SML",IF(AND(LEFT(T2,5)="Solar",OR(J2="NY",J2="NJ",J2="MA",J2="CT",J2="PA",J2="RI")),"SML",IF(AND(P2>9999,T2="Media - DICE",J2="CA"),"Mark Roth",IF(AND(W2="Physical",J2="CA"),IFERROR(VLOOKUP(K2,Sheet1!$C$2:$F$367,4,FALSE),IF(AND(W2="Physical",J2="CA", P2>10000,LEFT(T2,5)<>"Media"),"MISCO")),IF(AND(OR(J2<>"CA",J2<>"NY"),P2<3000),"OSI","Lowry"))))))))

what did I miss in the logic, and what edit is needed to result in a 'catch-all' to "Lowry"??

Thank you

 

[Scott Huish]

I can't find it but there must be a FALSE statement missing in there somewhere, but I think there is a logic problem in the last part of your formula.
The OR doesn't make sense there, I think that part should be:
,IF(AND(J2<>"CA",J2<>"NY",P2<3000),"OSI","Lowry")

And the reason the OR doesn't make sense is this. I think what you are trying to say is if J2 doesn't equal CA or NY and P2<3000 which is what my modification does.
Yours does this:

IF J2 was NY and P2<3000 your statement would return TRUE.
=OR(FALSE,TRUE) would return TRUE which I don't think is what you want.
and then
AND(TRUE,TRUE) which would return TRUE as well.

My AND statement would return FALSE:
=AND(FALSE,TRUE,TRUE) = FALSE

 

[igold]

Your are missing a "Value If False" argument in the red highlighted section...

=IF(W2="","",IF(W2="Close Even","U/W Process",IF(AND(F2=1,(LEFT(E2,7))=LEFT(E1,7)),X1,IF(T2="GC - Practice","SML",IF(AND(LEFT(T2,5)="Solar",OR(J2="NY",J2="NJ",J2="MA",J2="CT",J2="PA",J2="RI")),"SML",IF(AND(P2>9999,T2="Media - DICE",J2="CA"),"Mark Roth",IF(AND(W2="Physical",J2="CA"),IFERROR(VLOOKUP(K2,Sheet1!$C$2:$F$367,4,FALSE),IF(AND(W2="Physical",J2="CA", P2>10000,LEFT(T2,5)<>"Media"),"MISCO")),IF(AND(OR(J2<>"CA",J2<>"NY"),P2<3000),"OSI","Lowry"))))))))