Help me

[moshin123]

So i was given this question by my teacher and i solved it.

1. Copy the data onto a new worksheet.
2. It has been decided to offer a place if an applicant has a PASS in ANY THREE SUBJECTS for
the next academic year. Modify the formula to cater for the new rule.

HINT: There are 4 possibilities: (P,P,P,F), (F,P,P,P), (P, F,P,P) and (P,P,F,P). You will need to
Use both AND and OR Logical operators.
3. Change data for all possibilities and check each row’s outcome thoroughly


the solution is =IF(OR(AND(G33="Pass",H33="Pass",I33="Pass",J33="Pass"),AND(G33="Pass",H33="Pass",I33="Pass",J33="Fail"),AND(G33="Fail",H33="Pass",I33="Pass",J33="Pass"),AND(G33="Pass",H33="Fail",I33="Pass",J33="Pass"),AND(G33="Pass",H33="Pass",I33="Fail",J33="Pass")), "Yes","No")

however, the question is how would i make this shorter
and can u explain why it works

 

[Joe4]

Welcome to the Board!

however, the question is how would i make this shorter

Take a look at COUNTIF
https://www.techonthenet.com/excel/formulas/countif.php

You could also use 4 IF statements added together, where it returns 1 if that cell is Pass, otherwise return 0.
If the sum of those 4 equals 3, then your condition is met.

 

[63falcondude]

Do you have to use AND and OR operators? If not, you can simplify the formula to

=IF(COUNTIF(G33:J33,"Pass")>=3,"Yes","No")

 

[moshin123]

Thanks