software

In the following formula, I need to change N2gt;1 to get it to be TRUE if there
are any words in the cell:

=IF(J2gt;1,IF(K2gt;1,IF(L2gt;1,IF(M2gt;1,IF(N2gt;1,IF(T2gt;1,quot; 0-Completedquot;),quot;5-Progressingquot;),quot;4-Supervisor Req'dquot;),quot;3-Resubmittingquot;),quot;2-Submittingquot;),quot;1-No Proposalquot;)

how about
if(len(j2)gt;2

--
Don Guillett
SalesAid Software

quot;Peter Bluequot; lt;Peter gt; wrote in message
...
gt; In the following formula, I need to change N2gt;1 to get it to be TRUE if
gt; there
gt; are any words in the cell:
gt;
gt; =IF(J2gt;1,IF(K2gt;1,IF(L2gt;1,IF(M2gt;1,IF(N2gt;1,IF(T2gt;1,quot; 0-Completedquot;),quot;5-Progressingquot;),quot;4-Supervisor
gt; Req'dquot;),quot;3-Resubmittingquot;),quot;2-Submittingquot;),quot;1-No Proposalquot;)