multiple conditions coming up with one solution

[DHG BamaBlood94]

Alright so I have a problem.....Ive got an excel sheet that keep up with people in my gaming clan and many other things...well I have column that says if their eligable for promotions or not but theres many different conditions like Most of the conditions have to say "Yes" and one has to have a sum of "4" and I want it to say if their eligable for a promotion Yes but only if the conditions say "Yes" and have sum of "4"(From 2 columns)

 

[DHG BamaBlood94]

Also I need it to say if from the join date is 7 weeks then they are eligable