Excel function multiple IF Statements

[JMurphy2367]

Hi there I am trying to compute an excel funtion with multiple IF Statements, which I believe will also include OR and AND statements. Ultimately I want a function to read that IF cell D20 equals "EBW" or "Emco" and cell D28  is >= 26 then cell D30 shows a pass. If Cell D20 equals "OPW" and and cell D28 is => 12 then cell D30 shows a pass. If none of these conditions are met then cell D30 shows a fail. 

I appreciate any help in the matter and if more info is needed I will gladly provide it. Thanks!

I am using Office 365 Version 2112 

[#2 · Accepted solution]

@JMurphy2367 

=IF(OR(AND(D28>=12,D20="OPW"),AND(D28>=26,OR(D20="EBW",D20="Emco"))),"pass","fail")

Maybe with this formula. 

[#3]

@OliverScheurich  

You got it. Much appreciated!