=if(E7= "\", "\",if(E7= "TEU Supervisor", "Exempt",if(E7= "TEU Advisor", "Exempt",if(E7= "TEU Officer III", if(F7>=$X$4, if(sum(G7:O7)>=$X$5, "Meets Minimum Requirements","Doesn't Meet Requirements"),"Doesn't Meet Requirements"),if(E7= "TEU Officer II", if(F7>=$X$4,if(sum(G7:O7)>=$X$5,if(P7>=5,if(sum(G7:O7)>=3,"Meets Promotion Requirements","Meets Minimum Requirements"),"Meets Minimum Requirements"),"Doesn't Meet Requirements"),"Doesn't Meet Requirements"),if(E7:E= "TEU Officer I", if(F7>=$X$4, if(sum(G7:O7)>=$X$5, if(P7>=5,"Meets Promotion Requirements","Meets Minimum Requirements"),"Doesn't Meet Requirements"),"Doesn't Meet Requirements"),if(E7= "TEU Recruit", "Exempt",)))))))