Blank cell in formula
 

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

=IF(J21,IF(K21,IF(L21,IF(M21,IF(N21,IF(T21," 0-Completed"),"5-Progressing"),"4-Supervisor Req'd"),"3-Resubmitting"),"2-Submitting"),"1-No Proposal")

Blank cell in formula
 

how about
if(len(j2)2

--
Don Guillett
SalesAid Software

"Peter Blue" <Peter wrote in message
...
In the following formula, I need to change N21 to get it to be TRUE if
there
are any words in the cell:

=IF(J21,IF(K21,IF(L21,IF(M21,IF(N21,IF(T21," 0-Completed"),"5-Progressing"),"4-Supervisor
Req'd"),"3-Resubmitting"),"2-Submitting"),"1-No Proposal")