Add one more query

[taniab]

i have a formula that was provided in this forum.
=IF(AND(SUMPRODUCT(--ISNUMBER(SEARCH({"D","E"},J13)))>0=FALSE,SUMPRODUCT(--ISNUMBER(SEARCH({"Som","Sel","n/a"},K13&L13&M13&N13&O13&P13*Q13&R13)))>0=FALSE),"Advanced","")

I need to add one more thing into it.

I need it to check attendance %

If Attendance (E13) is less than 92%, exclude them (ie. say nothing), if it is more than 92% and meets all other criteria above, then they are considered Advanced.

Thanks

 

[mrshl9898]

Getting harder and harder to be Advanced these days.

=IF(AND(SUMPRODUCT(--E13)>0.92,SUMPRODUCT(--ISNUMBER(SEARCH({"D","E"},J13)))>0=FALSE,SUMPRODUCT(--ISNUMBER(SEARCH({"Som","Sel","n/a"},K13&L13&M13&N13&O13&P13*Q13&R13)))>0=FALSE),"Advanced","")

*note the >0.92 there. If 92% OR higher then make that >=0.92

 

[taniab]

Thank you