Help! Multiple formulas in one string

[metz321]

I'm trying to create a formula that will return a "yes" if specific criteria is met. However, the criteria is a bit complicated. Here is what I have do far, but I'm getting an error.

=IF(OR(AND(OR(B4="0001486",B4="0004972",B4="0001568"),L4>45),(AND(OR(B4="0003605",B4="0041133"),L4>30),(AND(OR(B4="0033495",B4="0000000"),L4>35)))),"yes","")

Please help!

 

[Robert Mika]

Try thi:
=IF(OR(AND(OR(B4={"0001486","0004972","0001568"}),L4>45),AND(OR(B4={"0003605","0041133"}),L4>30),AND(OR(B4={"0033495","0000000"}),L4>35)),"yes","")