Making IF Statement combining AND and OR

[misk0048]

Hello,

I'm trying to make an IF Statement where one cell must equal "BZ" and another cell can't be one of several values.

My current attempt is not working...

=IF(OR(LEFT($O2,4)<>"0940",LEFT($O2,4)<>"0950",LEFT($O2,4)<>"0740",AND(AB$1=$Q2)),1,"")

Any ideas?

 

[Scott Huish]

Is this what you need?

=IF(AND(AB$1=$Q2,LEFT($O2,4)<>{"0940","0950","0740"}),1,"")

 

[Joe4]

This thread was put in Moderated status, and was re-posted and answered here: https://www.mrexcel.com/forum/excel-questions/1036196-making-if-statement-combining.html