Multiple conditions

[apgmin]

Please help me with this. thanks in Advance

If Cell O2 is MBA ( It is in a drop down list )
then check the values of Cells Q2 to V2, if all of them are YES ( the drop down list has only 2 options YES or NO ) then it should display in cell D2 "admitted" or else "not admitted" ( even if the cells Q2 to V2 is all or any blank )

If Cell O2 is anything other than MBA ( It is in a drop down list )
then it should check the values of Cells Q2 to U2 only, if all of them are YES ( the drop down list has only 2 options YES or NO ) then it should display in cell D2 "admitted" or else "not admitted" ( even if the cells Q2 to U2 is all or any blank )

 

[Michael M]

Try

=IF(AND(O2="MBA",COUNTIF(Q2:V2,"YES")=6),"admitted","not admitted")

or

=IF(COUNTIF(Q2:V2,"YES")=6),"admitted","not admitted")

 

[apgmin]

If Cell O2 is anything other than MBA ( It is in a drop down list )
then it should check the values of Cells Q2 to U2 only, if all of them are YES ( the drop down list has only 2 options YES or NO ) then it should display in cell D2 "admitted" or else "not admitted" ( even if the cells Q2 to U2 is all or any blank )

this part does not work

 

[apgmin]

=IF(AND(O2="MASTER OF BUSINESS ADMINISTRATION",COUNTIF(Q2:V2,"YES")=6),"admitted",IF(AND(O2<>"MASTER OF BUSINESS ADMINISTRATION",COUNTIF(Q2:U2,"YES")=5),"admitted","not admitted"))

changed to the above, now it works perfectly.

By the way I like your tag line The more I learn, the less I seem to know

 

[Michael M]

Glad your modified formula worked...