left(aa7,5)<"secur"

--
Don Guillett
SalesAid Software

"Todd" wrote in message
...
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