Need some Help to Solve the formula of "Promoted" "Fail" or "Pass"

[vijubhau]

Hi Teacher,
In the adjoining XLSX file, in cell (U2) formula is working perfect upto 3 rows..
In the (U5) I need a formula result as "Fail" in spite of "Promoted" because one cell contained the value less than 35..

[vijubhau]

So Sorry... Kindly read (T2) and (T5) in spite of (U2) & (U5)..

[FDibbins]

You will need to give us the rules for your query.

[Phuocam]

Maybe?

=IF(OR(C2<=34,D2+E2<=34,J2<=34,K2<=34,L2<=34,M2<=34,Q2<=20),"FAIL",IF(COUNTIF(C2:Q2,"*+*")>0,"PROMOTED","PASS"))

[vijubhau]

Thank you Sir.. Problem has been solved..

[vijubhau]

Maybe?

=IF(OR(C2<=34,D2+E2<=34,J2<=34,K2<=34,L2<=34,M2<=34,Q2<=20),"FAIL",IF(COUNTIF(C2:Q2,"*+*")>0,"PROMOTED","PASS"))

Thank you Sir.. Problem has been solved..