Need help obtaining a formula

[mrafiq44]

So on the row i have different people such as Person A, Person B, Person C, etc.
And on the columns i have their duties such as - Cleaning, Drying, Building, Examining
So an example would be person A - Cleaning (Yes), Drying (No), Building (Yes), Examining (No)
Some of these duties are high level such as Cleaning and Drying - so i want to create a formula that a column in the end that would be Column 5 shows Yes because person A does perform a high level task.
Can someone please help me with this formula?

 

[Scott Huish]

To explain what Cubist is doing * is equivalent to using AND and + is equivalent to using OR.
This does exactly the same thing using AND and OR functions:
=IF(AND(B2<>"carpenter",OR(C2="Yes",E2="Yes")),"Yes","No")