Here is the formula I am using. The numeric if's work but the text one does
not. Cell AA7 contains a text statement and in that statement the term secure
or security might appear. If if does I want to return an "X". If it does
not I want to continue to evaluate the other cells.

IF(AA7<"secur",IF(AND(E7<"",F7<"",G7<"",I7<"" ,P7<""),IF(AND(Q7<"",S7<"",V7<"",Q7<"",AB7<" "),"P","X"),"X"),"P")

Thanks

Todd