Blank cell in formula

P

Peter Blue

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

=IF(J2>1,IF(K2>1,IF(L2>1,IF(M2>1,IF(N2>1,IF(T2>1,"0-Completed"),"5-Progressing"),"4-Supervisor Req'd"),"3-Resubmitting"),"2-Submitting"),"1-No Proposal")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Would like to input 3 letters into a cell, each having a different numerical value 5
IF AND 1
combining multiple columns using ", " seperations.. 4
Qual a melhor função logica a ser usada? 0
Dividing after a long formula 5
Bold items within text string 7
Forecast of Inventory - Explaination of Calcuations 1
Creating Different Headers in Word 0

Top